Answer / Upendra Pandey

To create a stored program unit (PL/SQL block, function, package, etc.) in Oracle, you can use the `CREATE [OR REPLACE] [PROCEDURE | FUNCTION | PACKAGE | ...]` statement. For example, to create a simple PL/SQL procedure, you can use: `CREATE OR REPLACE PROCEDURE my_proc IS BEGIN DBMS_OUTPUT.PUT_LINE('Hello World!'); END; /`.

What is Index and different types of Indexes?

7 Answers  

---

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers  

---

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

how do u setup a replication site?

1 Answers  

---

How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

1 Answers   IBM,

---

How would you extract DDL of a table without using a GUI tool?

1 Answers  

---

How to start your 10g xe server?

1 Answers  

---

What is a dynamic performance view in oracle?

1 Answers  

---

What is SQL Tuning Advisor in Oracle?

1 Answers   MCN Solutions,

---

what is the difference between UNION AND UNIONALL

4 Answers  

---

can u call user defined functions in select statements

2 Answers  

---

What is bulk copy or bcp in oracle?

1 Answers  

---