Answer / ram

many number of tables can be join in a sql query by using 'join'

Answer / jo

In where clause u can write 254 subqueries and in from
clause u can write n number of queries

Answer / sumit

its 256

Answer / o.sridevi

many number of tables can create but not at a time one after one

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

---

What are sql functions? Describe the different types of sql functions?

0 Answers  

---

What is sqlservr exe?

0 Answers  

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---

what is datawarehouse? : Sql dba

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

---

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 Answers   TCS,

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---

Mention what does plv msg allows you to do?

0 Answers  

---

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

---

Cite the differences between execution of triggers and stored procedures?

0 Answers  

---

How to run sql commands in sql*plus?

0 Answers  

---