1. Display the post code and the purchase order number for
each purchase order. Sort the output set by postcode.
What is the use of oracle?
Please explan Why static query is more faster than dynamic query ?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
How to Select second Maximum salary in a Table ?
Can we convert a date to char in oracle and if so, what would be the syntax?
What is TNS File
What is SYSTEM tablespace and When is it Created?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How do we get field detail of a table?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error