Answer / Siddharth Kumar

In SQL and PL/SQL, the [or replace] clause is used to replace specified characters in a string with other characters or remove them entirely. For example: replace(column_name, 'old_value', 'new_value')

How many triggers can be applied to a table?

1 Answers  

---

Do ddl statements need commit?

1 Answers  

---

Write a sql select query that only returns each name only once from a table?

1 Answers  

---

What is the use of stored procedures?

1 Answers  

---

How can a pl sql block be executed?

1 Answers  

---

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

---

what is indexing, searching and user interface?

1 Answers   HCL,

---

What is an Exception ? What are types of Exception ?

2 Answers  

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1 Answers  

---

What is difference between procedure and trigger?

1 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,

---

Why does %isopen return false for an implicit cursor?

1 Answers  

---