Answer Posted / jo
In where clause u can write 254 subqueries and in from
clause u can write n number of queries
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Can primary key be changed?
what is bcp? When does it used? : Sql dba
Advantages and disadvantages of stored procedure?
How are sql commands classified?
What are the rules to be applied to nulls whilst doing comparisons?
What is break?
what is the difference between a local and a global temporary table? : Sql dba
Where not exists in sql?
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
What are inbuilt functions in sql?
Describe different types of general function used in sql?
Which function is used to return remainder in a division operator in sql?
Explain select statements in sql?
Is nosql relational?
How do you optimize a query?