Answer Posted / swastik

SELECT * FROM
          (
           SELECT ROWNUM Rn, E1.*
           FROM Emp
           )
WHERE RN = 5
/

Explain constraints in sql?

1026

---

What is the difference between function, procedure and package in pl/sql?

1222

---

Can two tables have same primary key?

953

---

What is cursor status?

1176

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

978

---

How do I edit a trigger in sql developer?

970

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

936

---

Mention what does plv msg allows you to do?

1096

---

If a cursor is open, how can we find in a pl/sql block?

1148

---

How to get help at the sql prompt?

1100

---

what are all the common sql function? : Sql dba

1043

---

What is the primary use of normalization?

984

---

How do you write a subquery?

1004

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2050

---

What is compilation error in pl sql?

958

---