Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 180562 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / vishnu e s
join-is used to join two tables which have the same field
and same data type.
union-is to join two sql querrys....
| Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
what is the use of friend function? : Sql dba
Can a table have no primary key?
How to raise user-defined exception with custom sqlerrm ?
I need a function for a train ticket reservation please answer it thanks in advance
how to calculate expressions with sql statements? : Sql dba
Why do we go for stored procedures?
How to display Row Number with Records in Oracle SQL Plus?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
define data blocks ? : Sql dba
Is sql dba a good career? : SQL DBA
Is a secondary key the same as a foreign key?
Are subqueries faster than joins?
What is the basic form of sql query?
What are sql built in functions?
what are all different types of collation sensitivity? : Sql dba
