Answer Posted / manoj

delete from employee where sal = (select sal from (select sal from employee order by sal desc) where rownum = 3);

How to start instance with a minimal initialization parameter file?

1084

---

Explain oracle 12c new features for developers?

1125

---

How to rename an index in oracle?

1168

---

How to establish administrator authentication to the server?

1095

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

2007

---

What are the roles of dba?

1136

---

what is insert all statement in sql

6622

---

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2090

---

Explain the features of oracle?

1107

---

What is a partition in oracle?

1204

---

How to use like conditions in oracle?

1113

---

What are the major difference between truncate and delete?

1131

---

How to rename a tablespace in oracle?

1124

---

What is a trace file and how is it created in oracle?

1140

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2197

---