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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.