Answer Posted / kuldeep

CREATE TABLE A
(
ID NUMBER
)
NOLOGGING;

INSERT /*+APPEND*/ INTO A(ID)
SELECT LEVEL
FROM DUAL
CONNECT BY LEVEL <= 100000;
COMMIT;

SELECT *
FROM A;

How to get the Installed Oracle Version Information ?

633

---

What happens to the data files if a tablespace is dropped?

588

---

How different is ms access and oracle?

562

---

What is oracle host variable?

542

---

How do I spool to a csv formatted file using sqlplus?

554

---

---

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?

946

---

What is a tns file?

510

---

What are the attributes of cursor?

597

---

How to define an oracle cursor variable?

584

---

How translate command is different from replace?

552

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

561

---

What are the general rules on data consistency?

595

---

How to connect to the server with user account: sys?

569

---

When system tablespace is created?

614

---

Briefly explain what is literal? Give an example where it can be used?

552

---