how to include character strings in sql statements? : Sql dba

0 Answers  

---

Should I use mbr or gpt?

0 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

What is rank function in sql?

0 Answers  

---

Why are cursors used?

0 Answers  

---

Can we use rowid as primary key?

0 Answers  

---

What is the difference between function, procedure and package in pl/sql?

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

What is delete command in sql?

0 Answers  

---

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

---

How to look at the current sql*plus system settings?

0 Answers  

---

How do I view stored procedures?

0 Answers  

---