Answer Posted / s. senthil kumar
There are Two Types of joins:
I. Inner Join
II. Outer Join
I: Inner join:a) Equi join, b) Non Equi join c) self join
II: Outer join: a) Left outer join, b) right outer join,
c) Full outer join
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to create tables for odbc connection testing?
Explain about functional dependency and its relation with table design?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
candidate key is subset of super key but not vice-verse explain
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to check your oracle database 10g xe installation?
What is program global area (pga) in oracle?
Are truncate and delete commands same? If so why?
Can we call procedure inside function in oracle?
Explain compound trigger in oracle?
What is where clause in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
What do you mean by group by clause?
When system tablespace is created?