The join defined by the default data link is an outer join
yes or no ?
- 1 Answers
- 5782 Views
- Oracle, I also Faced
- E-Mail Answers
Answer / meenakshi
No its not outer join
but it is an equi/natural join
| Is This Answer Correct ? | 6 Yes | 0 No |
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
Display the records between two range?
What is an external table?
How to get a list of all background sessions in the database?
how to genarate random numbers in oracle for particular row?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is logical backup in oracle?
what are the diffeenes between oracle 9i,oracle 10g
How to get maxsal , minsal, ename department wise in single query
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
what is the use of system.effective.date variable in oracle?
Oracle General 
