Answer Posted / guest

select rowid,[optional columns...] from table where
rowid='n';
--n would be the input from the user which will let you
identify the row number of that particular record

Why do we use %rowtype & %type in plsql?

992

---

What is sql indexing?

964

---

What is sql lookup?

864

---

what is a join? : Sql dba

961

---

How many types of primary keys are there?

978

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

954

---

Are stored procedures compiled?

871

---

How many commands are there in sql?

971

---

Which function is used to return remainder in a division operator in sql?

1074

---

what is the use of set statement in tsql? : Transact sql

943

---

what is commit? : Sql dba

1026

---

What is cursor status?

1135

---

what is dbms? : Sql dba

932

---

What are the basic sql commands?

1037

---

What is a temporal table?

881

---