What is the default value of CHAR type?

3 Answers   Bosch,

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

What is the process of debugging?

0 Answers  

---

What is partition by in sql?

0 Answers  

---

what is data integrity

3 Answers   Fidelity, TCS,

---

How long it takes to learn pl sql?

0 Answers  

---

What is an alias command?

0 Answers  

---

query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,

---

How will you distinguish a global variable with a local variable in pl/sql?

0 Answers  

---

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

what are the advantages a stored procedure? : Sql dba

0 Answers  

---