What is sql query limit?

0 Answers  

---

How many parts of a pl sql block are optional?

0 Answers  

---

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

What is sql not null constraint?

0 Answers  

---

---

What are system versioned tables?

0 Answers  

---

What do you know by pl/sql cursors?

0 Answers  

---

what is a composite primary key ? : Sql dba

0 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

What is extent clause in table space?

1 Answers   TCS,

---

give the syntax of grant and revoke commands? : Sql dba

0 Answers  

---