Does sql*plus also have a pl/sql engine?

0 Answers  

---

Will truncate release space?

0 Answers  

---

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

0 Answers  

---

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  

---

How to get list of all tables from a database?

0 Answers  

---

What is a .db file?

0 Answers  

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

0 Answers  

---

What is difference between stored procedure and trigger?

0 Answers  

---

How do I remove sql plus from windows 10?

0 Answers  

---

What is the unique index?

0 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---