Explain the use of Merge statement in oracle 11g
No Answer is Posted For this Question
Be the First to Post Answer
How to write a left outer join with the where clause in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
Explain an exception and its types?
Explain the use of rows option in exp command.
how to truncate date and get only time part 9:20:00
How to do clean up if create database failed?
How to select the name of employee who is getting maximum sal with out using subquery
What is an Index Segment ?
How different is ms access and oracle?