Answer Posted / elumalai d

CREATE TABLE emp(ID NUMBER(10),NAME VARCHAR2(100),salary NUMBER(10));

INSERT INTO emp VALUES(100,'Steven',40000);
INSERT INTO emp VALUES(101,'Smith',30000);
INSERT INTO emp VALUES(102,'Ranshow',70000);
INSERT INTO emp VALUES(103,'Handscomp',20000);
INSERT INTO emp VALUES(104,'Mitchel',10000);
INSERT INTO emp VALUES(105,'Clarke',90000);
INSERT INTO emp VALUES(106,'Ponting',50000);
INSERT INTO emp VALUES(107,'Clarke',80000);
INSERT INTO emp VALUES(108,'Marsh',60000);
COMMIT;

SELECT salary FROM emp ORDER BY salary DESC;

--Records
--======
90000
80000
70000
60000
50000
40000
30000
20000
10000

SELECT min(salary) FROM (SELECT salary FROM emp ORDER BY salary DESC) WHERE ROWNUM<3;

Difference between varchar and varchar2 data types?

1262

---

What is recovery manager in Oracle?

1109

---

How to define a specific record type?

1136

---

How to convert characters to numbers in oracle?

1112

---

What is an oracle?

1066

---

Explain about integrity constraint?

1176

---

What is an oracle cursor variable?

1133

---

What is redo log?

1113

---

What is query image?

1023

---

Write a trigger example in oracle?

1114

---

What is set operator oracle?

1035

---

what are archived logs?

2260

---

what are the default admin accounts in Oracle 10g ?

1022

---

How to export data with a field delimiter?

1085

---

what is the difference between functional dependecy and multilevel dependency?

2519

---