What is primary key and foreign key?
No Answer is Posted For this Question
Be the First to Post Answer
What is a field in a database?
What is the use of double ampersand (&&) in sql queries? Give an example
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 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?
how to create user in sql and how to set password for that?
what are properties of a transaction? : Sql dba
SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;
What does the hierarchical profiler does?
What is server name sql?
diff b/w sub query and co-relater query?
What are the different types of dbmss?
My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?