How to use existing values in update statements using oracle?

0 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

How to retrieve 5th highest sal from emp table?

8 Answers  

---

How to define a sub function?

0 Answers  

---

What privilege is needed for a user to delete rows from tables in another schema?

0 Answers  

---

How to convert raw data type into text in oracle? Explain

0 Answers  

---

How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10

2 Answers  

---

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

1 Answers  

---

What are the components of Physical database structure of Oracle Database?

4 Answers  

---

i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?

5 Answers   Oracle,

---

why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

1 Answers   Goldman Sachs,

---

Please explan Why static query is more faster than dynamic query ?

2 Answers  

---