Oracle

I face problems to extract data from one table and insert it in another one
Hi, For modifications, I have to extract data from one table and insert it in another one, after this I have to get the new id from the second tabl

At max how many columns is advisable to create in a table/view
Hi All, I have two transaction table from which i want to create a simple view or materialized view. But the number of columns is about 200. So

data type in column definition
Hi, I create a table with column called "Direction of Travel code ". The travel codes in the functional spec are numbers. In the column definition

Add_Months not Easy to Understand
Oracle is number 1, very fast and very easy. But.... OK, I think but have a problem, only 1 problem I can Found until now. (Even, you can see SQL Sev

Number Format
Hi All, I have number '000000000050085' I want to format it to 500.85 Can any one give me the logic?

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

cyrillic string conversion question
Hello, First time here... I would like to know if there is a way to convert a text string from cyrillic to latin. Should I use a function?

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 data look like

Problem Dereferencing
With these types and tables: CREATE TYPE MANAGER AS OBJECT ( MGR_ID INTEGER, LAST_NAME VARCHAR(40), FIRST_NAME VARCHAR(40), PHONE ch

am I using this for loop correctly
Dear buddies! Right now I am generating a report with some details for all the dealers. I am required to separate the report for each dealer res

Need help with basic sql
Hi, I am using oracle 10g, and having some small doubts related to sql , here goes the situation I have a Transaction table , which contains rec

Cursor statement failed with errors
Following statement failed with the errors. cursor proj_cursor1 is (select projectID from dsqa.table1 where projectID = any(select projectID from d

Revoking alter any table from a schema
Hi All, i am working in Oracle 10g. my requirement is to revoke all kind of DDL operations(except creating procedure etc) from a schema or user. f

Consuming third party Payment Gateway API from Procedure.
Hi All, First of all i would like to thank all the people of the oracle forum for providing very good solutions. Here is my query. We are imp

query help
Hi experts. i have a table rep2 like this PROD_COD ACCT_NO DUE_DAYS BALANCE LIMIT 1 1 101 15 100 200 2 1 102 17 150 200 3 1 103 32 500

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

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: decimal(decimal(A.record_count-A.generic_c

how to populate a drop down box
Hi buddies! PROCEDURE DOWNLOAD_REPORT_FORM (report_name varchar) is begin DOWNLOAD_REPORT_HEADER(report_name); htp.p('