Answer Posted / ketul

Select * From Table_Name Where 1 = 2;

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

2497

---

differentiate between float and double. : Sql dba

1110

---

What are all the ddl commands?

1244

---

Why use triggers in sql?

1013

---

How do you delete data from a table?

1104

---

What does where 1 1 mean in sql?

1079

---

Are stored procedures faster than dynamic sql?

1107

---

How do I run a script in sql developer?

1000

---

Is primary key is clustered index?

1045

---

what is normalization? : Sql dba

1137

---

What is difference between inner join and self join?

1137

---

What is mutating error?

1008

---

Determine if oracle date is on a weekend?

1091

---

What is nvarchar in sql?

978

---

How to get unique records from a table?

1024

---