Answer Posted / sajid siddiki

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal < = b.sal);
For Eg:-
Enter value for n: 100
SAL
---------
3700

What is a database event trigger?

1211

---

How to get help at the sql prompt?

1163

---

What is trigger and stored procedure in sql?

1092

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1639

---

what is a control file ? : Sql dba

1090

---

What is sql and how does it work?

1251

---

Explain clause in sql?

1073

---

What is the size of partition table?

1089

---

Can we group by two columns in sql?

1046

---

how to rename an existing column in a table? : Sql dba

1082

---

Can we join 3 tables in sql?

1108

---

Which software is used for pl sql programming?

1034

---

Explain what is an index?

1104

---

what are the different functions in sorting an array? : Sql dba

1067

---

How many joins in sql?

1058

---