Answer / Ajay Singh Chauhan

A primary key uniquely identifies each record within a table, while a secondary key provides another means of identifying records. A table can have only one primary key but multiple secondary keys.

How to use boolean type in select statement?

1 Answers  

---

What are different functions in sql?

1 Answers  

---

What are inner and outer joins examples of both?

1 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 difernece between named and anonymous pl/sql blocks??

8 Answers   TCS, Wells Fargo,

---

What is the sql case statement?

1 Answers  

---

How to read xml file in oracle pl sql?

1 Answers  

---

What is mutating trigger?

1 Answers  

---

What is minus?

1 Answers  

---

What do you mean by stored procedures?

1 Answers  

---

How to return multiple rows from the stored procedure?

1 Answers  

---

What is a scalar value in sql?

1 Answers  

---