Answer Posted / ratnakar

select max(sal) from emp a where 3=(select count(sal) from
emp b where b.sal >=a.sal;

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2465

---

Explain the structure of pl/sql in brief.

1057

---

How many scalar data types are supported in pl/sql?

996

---

How are sql commands classified?

1056

---

How would you pass hints to the sql processor?

945

---

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

1115

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1234

---

What is the maximum size of sqlite database?

1069

---

What is difference between my sql and sql?

1020

---

What does the argument [or replace] do?

1042

---

Which table is left in join?

927

---

What are its different types of dbms?

978

---

When are we going to use truncate and delete?

941

---

Define the select into statement.

1009

---

What are the parts of a sql statement?

1049

---