Answer Posted / neeraj sinha

suppose you have two databases: db1 and db2
you have to select one of them
as
sql>use db1;
then use
sql>select * from tab;
it will show you the listing required.!

which operator is used in query for pattern matching? : Sql dba

1007

---

How will you distinguish a global variable with a local variable in pl/sql?

1154

---

What are the differences between in and exists clause?

1111

---

Which are the different types of indexes in sql?

1061

---

what does the t-sql command ident_current does? : Transact sql

982

---

What are the types of join and explain each?

1048

---

How do I run a sql query?

1022

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

4017

---

What is compilation error in pl sql?

979

---

What will you get by the cursor attribute sql%notfound?

1074

---

What are the benefits of pl/sql packages?

1107

---

Can you inner join the same table?

991

---

Can we use view in stored procedure?

902

---

What is cte sql?

997

---

what are the 'mysql' command line options? : Sql dba

1072

---