I face problems to extract data from one table and insert it in another one
Hi,
At max how many columns is advisable to create in a table/view
Hi All,
data type in column definition
Hi,
Add_Months not Easy to Understand
Oracle is number 1, very fast and very easy. But....
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.