What will be the syntax to find current date and time in format "yyyy-mm-dd"?

0 Answers  

---

What is a deadlock in SQL? How can you prevent it?

1 Answers  

---

Give the constructs of a package, function or a procedure.

0 Answers  

---

Explain the importance of .pll extension in oracle?

0 Answers  

---

how the indexes are stored in the Oracle Database?

0 Answers  

---

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

---

1.display list of all users from ur data base.what is the query?

3 Answers   CGI, IBM,

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

0 Answers  

---

What is a user account in oracle?

0 Answers  

---

What is Read-Only Transaction ?

3 Answers  

---

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers   TCS,

---

Explain temporal data types in oracle

0 Answers  

---