Answer / sourav

From Unix OS type the following command :

SQL>!ls

From Windows the command is :

SQL> HO[ST] [command]

Answer / nasir mehmood

HOST('Os Command') procedure will be used for this purpose.

Answer / praveen

You would need to wrap OS command under External Procedure.
Read more about PL/SQL External Procedures on how the same
works.

What is the largest value that can be stored in a byte data field?

0 Answers  

---

What are system versioned tables?

0 Answers  

---

use of IN/ANY/ALL

5 Answers   Ramco,

---

What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,

---

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

---

How do you declare a constant?

0 Answers  

---

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

Show code of a cursor for loop.

0 Answers  

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  

---

What are the qualities of 2nf?

0 Answers  

---

Do we need to rebuild index after truncate?

0 Answers  

---

What is difference between hql and native sql?

0 Answers  

---