Search results for query: *

Anand, I you have a support contract with Oracle, just order for a new set of cds using metalink. Jitendra

Freak1, IBM has definately not stopped selling or supporting the As/400. They have just renamed the product. Hope this helps

Hi, Try the following : insert into cust_functions (SELECT 'CODE1' <colname>, cust_id, 'LWTest' <colname1>, sysdate FROM customers WHERE cust_type_cd = 'distributor'); Replace colname and colname1 with the actual column names from the target table cust_functions. Hope this helps

Hi, Lot of ways. 1. Write a plsql procedure to read from one table to write to another. 2. Export from source table to a flat file and use sqlloader to load it into target table. 3. Use a tool like TOAD to create sql statements from the source table, modify the result by changing the name of...

Hi, I you are creating a table create table test ( a varchar2(10), b varchar2(10), c varchar2(10), constraint pk_test primary key (a,b) ); If you are creating a unique index create unique index ind_test on test (a, b) ; Hope this helps.

Hi Manasir, This looks to be a gzip file, which available for download. I do not remember the site, but you easily find it using any search engine like google. You make be able to open it using winzip also. Hope this helps.

Hi, You will have to pick up the description from the table fnd_flex_values_tl which is linked to the fnd_flex_values by flex_value_id. Hope this helps.

Xpress, Assuming you have access to metalink, look up Electornic Technical Manuals (by selecting menu option ebusniess11i). Refer to the documentation for interface procedures for specific manuals by selecting the menu option Top Tech Docs, Hope this helps

Hi, What data do you want to convert ? Typically, you create a staging table, load data from flat files to this table. Develop a pl/sql routine to populate the interface tables from the staging table and execute the interface programs. Thanks

Vishnu, If you have access to metalink, refer to note 131299.1. I am assuming that you have a Pentium 4 processor. If this is true, try the following : 1. Copy the contents of the installation cd to a temp. folder. 2. Search for all copies of the symcjit.dll and rename them. 3. Go to the...

Hi, You could use command center. After writing a sql query, the result set can be changed and committed.