How do I clear the screen in sql plus?

0 Answers  

---

How many types of sql are there?

0 Answers  

---

What does the argument [or replace] do?

0 Answers  

---

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

State the advatage and disadvantage of Cursor's?

2 Answers  

---

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

---

How does one load ebcdic data? : aql loader

0 Answers  

---

What do you mean by query optimization?

0 Answers  

---

What is assignment operator in pl sql?

0 Answers  

---

What are the advantages of pl sql over sql?

0 Answers  

---

what happens if null values are involved in expressions? : Sql dba

0 Answers  

---