table creation create table product(pro_id number(5),pro

Hi how to import oracle sequence in Informatica? Please
write stored procedure code that will import oracle sequence
in Informatica SP transformation as per below scenario
Oracle table product list
Pro_id, pro_name, price
101, LED Lights,200
102, 20 watt CFL Lights, 145
103, 30 watt CFL lights,155
Now a new flat file with new product list needs to be added
to oracle table product list with oracle sequence
flat file product list has two column
pro_name, price
20 watt tube light ,45
30 watt tube light ,60

Question Posted / meenakshi sundaram

1 Answers
5778 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / meenakshi sundaram

table creation
create table product(pro_id number(5),pro_name varchar2
(15),price number(5));

insert the value in table:
insert into product values(101,'led lights',200);
insert into product values(102,'20 watt cfl lights,145);
insert into product values(103,'30 watt cfl lights,155);

or

insert into product values(&pro_id ,'&pro_name',&price);

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the importance of partitioning in dbms?

933

What is a table called in database?

934

What is write ahead logging in DBMS?

1050

What are the limitations of database?

850

How to create a database from my program?

1054

How to debug stored procedures?

918

What is management system in dbms?

890

What is 1nf in the dbms?

958

What is the sql 'in' clause?

915

What is inner join in database?

951

How index hunting contributes in improving the query performance?

913

Define fragmentation.

847

List few restrictions that are imposed while creating views?

852

What is natural key?

945

What is stored procedure in database?

907