Answer Posted / alok mbbs

I disagree with Karan and Vivek , i guess they are moving
away from the path .... answer is not upto the mark reason
being :::


Function cannot change the value in table.

Anyone disagree call me @

02267802321
i will explain in detail .....

Any appreciations call me for that

how to check myisam tables for errors? : Sql dba

1256

---

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

958

---

what is the difference between a local and a global temporary table? : Sql dba

1003

---

What is a string data type in sql?

956

---

what are the differences between binary and varbinary? : Sql dba

976

---

Why do we use partitions in sql?

971

---

What does sign mean sql?

1019

---

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...

2364

---

What does fetching a cursor do?

1018

---

Can two tables have same primary key?

915

---

what is the syntax used for partition in tsql? : Transact sql

955

---

What does select * from mean in sql?

3065

---

What are the two types of cursors in pl sql?

1001

---

Can we group by two columns in sql?

942

---

what is data control language? : Sql dba

955

---