What is sql not null constraint?

0 Answers  

---

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

How many types of triggers exist in pl/sql?

0 Answers  

---

what are the types of join and explain each? : Sql dba

0 Answers  

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---

Can we create view in stored procedure?

0 Answers  

---

Difference between NVL, NVL2 and NULLIF

1 Answers   CTS, Metric Stream,

---

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  

---

Which tcp/ip port does sql server run?

0 Answers  

---

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

---