Answer / Satya Swarup Anand

{"datatypes": "PL/SQL supports a wide range of scalar and collection datatypes, including: Scalar datatypes like CHAR, VARCHAR2, NUMBER, DATE, BOOLEAN, RECORD; Collection datatypes like ARRAY, VARRAY, TABLE, NESTED TABLE, REF CURSOR.", "example": "DECLARE my_array ARRAY(1..3) OF INTEGER; BEGIN NULL; END;"}

Does sql support programming?

1 Answers  

---

Define concurrency control. : Transact sql

1 Answers  

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1 Answers  

---

What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers   TCS,

---

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

---

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  

---

How do I view a sql trace file?

1 Answers  

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1 Answers  

---

What does partition by mean in sql?

1 Answers  

---

What are the Diff B/W Cursor and REF Cursor

3 Answers   CTS,

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1 Answers  

---

What's the difference between inner join and left join?

1 Answers  

---