Answer / prativa mishra

SELECT * FROM TABLE_NAME WHERE ROWNUM=1

Answer / hai

select * from table_name where rownum<2;

Is it important to partition hard disk?

0 Answers  

---

Explain the purpose of %type and %rowtype data types with the example?

0 Answers  

---

what is a constraint? : Sql dba

0 Answers  

---

Can we interchange parameters in procedure while calling

1 Answers   TCS,

---

What is sqlerrm?

0 Answers  

---

---

Can we create table in function?

0 Answers  

---

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers   Sierra Atlantica,

---

How many sql statements are used? Define them.

0 Answers  

---

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

0 Answers  

---

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  

---

how to get a list of indexes of an existing table? : Sql dba

0 Answers  

---

How many times can we commit in a loop?

0 Answers  

---