Explain scalar functions in sql?

0 Answers  

---

What is a join query?

0 Answers  

---

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

---

How bulk collect improves performance?

0 Answers  

---

Delete duplicate records in the emp table.

6 Answers   Oracle,

---

how to create user in sql and how to set password for that?

3 Answers  

---

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  

---

what happens if you no create privilege in a database? : Sql dba

0 Answers  

---

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

0 Answers  

---

What are different functions in sql?

0 Answers  

---

what is foreign key? : Sql dba

0 Answers  

---

Why do we use cursors?

0 Answers  

---