Answer Posted / avi007

full outer join -

select * from table1,table2 where
table1.columnname(+)=table2.colunmname;
union
select * from table1,table2 where
table1.columnname =table2.colunmname(+);

What is scalar and vector?

936

---

How do I start sql from command line?

962

---

What is a record in a database?

993

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

975

---

What is on delete set null?

1038

---

What is over () in sql?

892

---

What is a delimiter in sas?

978

---

What is aggregate function in sql?

984

---

What are stored procedures in mysql?

968

---

what is a view? : Sql dba

1026

---

what is the use of set statement in tsql? : Transact sql

943

---

What is mdf ldf and ndf?

931

---

What is exit statement?

957

---

What is an exception in PL/SQL? What are the two types of exceptions?

1193

---

What are the different sql languages?

985

---