Answer Posted / murugavel. u

ya..it's possible when, a table contains more than one
fields. we can able to set the primary for two or more..

thanks.,

Why we use stored procedure instead of query?

998

---

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

2448

---

How do I audit the sql sent to the server?

1010

---

How can a pl sql block be executed?

945

---

Is sql harder than python?

1108

---

Why do we use triggers?

967

---

What is the source code of a program?

1069

---

What is insert command in sql?

1129

---

what is foreign key? : Sql dba

1049

---

What is the starting oracle error number?

1055

---

What is the basic form of sql query?

943

---

Which constraints we can use while creating database in sql?

1081

---

What is difference between sql and mysql?

1132

---

What is a crud api?

954

---

how to create a new view in mysql? : Sql dba

935

---