Answer / prativa mishra

SELECT * FROM TABLE_NAME WHERE ROWNUM=1

Answer / hai

select * from table_name where rownum<2;

What is the use of sql trace?

0 Answers  

---

What is difference between left and right outer join?

0 Answers  

---

What is prepared statement in sql?

0 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

How can I create a table from another table without copying any values from the old table?

8 Answers  

---

---

What is assignment operator in pl sql?

0 Answers  

---

what are the features and advantages of object-oriented programming? : Sql dba

0 Answers  

---

What is a Procedure ?

3 Answers  

---

What are different types of queries in sql?

0 Answers  

---

What are the differences between implicit and explicit cursors?

0 Answers  

---

how can you see all indexes defined for a table? : Sql dba

0 Answers  

---

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---