Answer Posted / highness

mainly two types
1. scalar 2. composite

1.
boolean
char
binary integer
number
variable
constant
raw
rowid


2.
records
tables
varrays

What is substitution variable?

1049

---

Can a commit statement be executed as part of a trigger?

1048

---

Can triggers stop a dml statement from executing on a table?

1085

---

What is set transaction?

1035

---

Can a procedure in a package be overloaded?

1043

---

Does truncate need commit?

940

---

what is transaction? : Sql dba

1006

---

What is a left inner join?

1011

---

Give the order of sql select?

1133

---

What will you get by the cursor attribute sql%found?

961

---

What are expressions?

1009

---

How many sql statements are used?

1007

---

Why we use stored procedure instead of query?

997

---

what is the difference between join and union? : Sql dba

1111

---

Explain exception handling in pl/sql?

1033

---