Answer Posted / omprakash.jsm
Inner join return rows from many tables where the join field and data type are equal.
outer join return rows from many tables where the join field are not equal but data type will be same.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the sql query to concatenate column values from multiple rows in oracle?
what are bitmap indexes? How does they work?
Can the query output be sorted by multiple columns in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is the implicit cursor in oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Is it possible to split the print reviewer into more than one region ?
How to convert characters to numbers in oracle?
How to generate query output in html format?
How to create a server parameter file?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what are steps for interface? where is exchange rate defined in which table?
What is system global area (sga) in oracle?
How would you change old and new values in an insert, delete and update triggers?
