Answer Posted / suneelkumar

Hi guys..

rownum is virtual column we con't use max(rownum) i t will
give the error unknown colum...

so by using cursor we can count

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1034

---

how to create a table index in mysql? : Sql dba

1050

---

Give the order of sql select?

1132

---

What are tables and fields?

1027

---

What is pl sql in oracle?

1037

---

Why is normalization important?

1019

---

How do you explain an index number?

1093

---

What is Collation Sensitivity ? What are the various type ?

945

---

What are the triggers associated with image items?

1034

---

What is a sql trace file?

1021

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4004

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

966

---

What are the types of variable use in pl sql?

1066

---

What is natural join in sql?

978

---

how can we repair a mysql table? : Sql dba

967

---