Answer Posted / kumar
Types of joins are :
Equi-Join
Non-Equi-Join
Right Outer Join
Left Outer Join
Full Outer Join
Self Join
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the restrictions on external table columns?
How to display row numbers with the records?
Is java required for oracle client?
Can we save images in a database and if yes, how?
Can group functions be mixed with non-group selection fields?
How to join two tables in a single query using oracle?
What privilege is needed for a user to delete rows from tables in another schema?
Explain the use of inctype option in exp command.
How to pass a parameter to a cursor in oracle?
How to use select statement to count the number of rows in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to add a new column to an existing table in oracle?
Explain mutating triggers.
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
what is port in oracle? how is it related to database application.