Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

7 Answers   PreVator,

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

0 Answers  

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,

---

what is an extent ? : Sql dba

0 Answers  

---

---

What is sql character function?

0 Answers  

---

If a View on a single base table is manipulated will the changes be reflected on the base table?

5 Answers  

---

Name the different types of indexes in sql and define them.

0 Answers  

---

Is it possible to access the current value in a session before accessing next value?

1 Answers  

---

What is a column in a table?

0 Answers  

---

What is the use of procedures?

0 Answers  

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---