Answer Posted / samir kumar sahoo
Generally there are five types of joins in oracle:
Self Join
Equi Join
Cartesian Join
Outer Join(Left outer join,Right outer join)
Non_Equi JOin
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain the use of full option in exp command.
Is oracle a relational database?
What is the difference between count (*), count (expression), count (distinct expression)?
Explain mutating triggers.
Explain the use of consistent option in exp command.
What is a user role in oracle?
What is the difference between postgresql and oracle?
How does one get the view definition of fixed views/tables?
What are dml statements in oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Can we call procedure inside function in oracle?
How to create an oracle database manually?
Explain integrity constraint?
Explain the use of indexes option in imp command.
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
