Answer / Deep Shikha Singh

SQL Tuning Advisor is an Oracle feature that helps to improve the performance of SQL statements by analyzing their execution plans and suggesting more efficient alternatives. It can be invoked using the DBMS_SQLTUNE package or through the Enterprise Manager Console.

How to increment dates by 1 in oracle?

1 Answers  

---

What are the arithmetic operations?

1 Answers  

---

How to define a sub function?

1 Answers  

---

Can multiple columns be used in group by in oracle?

1 Answers  

---

What is the maximum number of CHECK constraints that can be defined on a column ?

3 Answers  

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

1 Answers   Cisco,

---

how to insert the image in table

2 Answers  

---

How to restrict the duplicate records in table valuesets

2 Answers   IBM,

---

What are the advantages of Views ?

3 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1 Answers  

---

i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately

1 Answers  

---

what are different types of locks?

6 Answers  

---