What are the set operators union, union all, minus & intersect meant to do?
No Answer is Posted For this Question
Be the First to Post Answer
How are extents allocated to a segment?
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
How to use "in" parameter properly?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What is merge in oracle?
Tell me New Feature of Oracle 10g?
How to retrieve 5th highest sal from emp table?
How to loop through a cursor variable?
How to get maxsal , minsal, ename department wise in single query