Forums

Number Format

Hi All,

PL/SQL: ORA-00947: not enough values error message

Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing following insert statement. I am new to Oracle SPs, so could someone help me to solve the issue.

cyrillic string conversion question

Hello,

Random date selection

i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and timestamp is specified 10-11 am

Problem Dereferencing

With these types and tables:

am I using this for loop correctly

Dear buddies!

Need help with basic sql

Hi,

Cursor statement failed with errors

Following statement failed with the errors.

Revoking alter any table from a schema

Hi All,

Consuming third party Payment Gateway API from Procedure.

Hi All,

query help

Hi experts.

Execure stored procedure on a timer

Can someone tell me an easier way to execute a stored procedure on a timer? I am using Oracle 10g R2 DB on windows 2003 server. I have a batch file that calls an SQL file, which runs fine when I

Casting Decimals in Oracle

This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Oracle:

how to populate a drop down box

Hi buddies!

SQL query not working well

Hi,

Data storage spaces in varchar2

Trying to understand what's happening.

Find current logon time

Hi,

Escape Latin Characters

I need to escape latin characters in an xml doc. Example: "é" is escaped to "é". I thought I could use the ASCII function, but SELECT ASCII('é') FROM DUAL in Oracle gives me 50089.

please help me in this update statment

hi every one

help with multi-update

Now sure how to ask this really....