Answer Posted / peter

Schema is a collection of database objects. A schema is
owned by a database user and has the same name as that
user. Schema objects are logical structures created by
users to contain, or reference, their data. Schema objects
include structures like tables, views, and indexes.

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1992

---

What is literal?

1062

---

Please explain joins in oracle?

1104

---

How to retrieve data from an cursor to a record?

1155

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1437

---

Difference between cartesian join and cross join?

1093

---

What happens to the current transaction if a ddl statement is executed?

1059

---

What is oracle datasource?

1039

---

How to initialize variables with default values?

1306

---

What is oracle update statement with inner join ?

1114

---

How to drop an index?

1013

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2334

---

How to sort the query output in oracle?

1073

---

How many file formats are supported to export data?

1266

---

Explain how are indexes update?

1119

---