Answer Posted / anjum
There are four types of joins
Inner join (Equi join,Non Equi join)
Outer join (Left outer, Right outer,Full outer)
Self join
Cartesian join
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a nested table and how is it different from a normal table?
How will you differentiate between varchar & varchar2?
How can we create the complete backup of data in the oracle.
How to change user password in oracle?
Explain the features of oracle?
What to do if the binary spfile is wrong for the default instance?
Can sub procedure/function be called recursively?
How to connect to the server with user account: sys?
How to turn on or off recycle bin for the session?
What is Library Cache in Oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Explain do view contain data?
How to use fetch statement in a loop?
What is tns entry?