A and B are tables. x is a column. Then What is difference
between A.x = B.x(+) and A.x = B.x ?
Answer Posted / subha
A.x=B.x(+) will display all the vlaues of X from B table
and Deficient information of A table.
IT is right outer join concept.
where as
A.x=B.x will display records that are matching from both
the tables.
| Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
How will you write a query to get a 5th rank student from a table student_report?
What are the database administrators utilities available?
How to find out what oracle odbc drivers are installed?
How to connect to a local oracle 10g xe server?
What is clustered table in Oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Is primary key indexed by default in oracle?
What is a sub query? Describe its types?
State all possible different index configurations a table can possibly have?
How much memory your 10g xe server is using?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Describe the types of sub query?
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.
How to delete a column in an existing table?
How do I limit the number of oracle database connections generated by weblogic server?