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;

What is the relationship among database, tablespace and data file?

627

---

How to delete a column in an existing table in oracle?

674

---

How to write a query with a right outer join in oracle?

699

---

What is the dynamic sql in oracle?

687

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1279

---

---

What is the data pump import utility?

676

---

What are the different types of failures that occur in Oracle database?

696

---

How do I reset a sequence in oracle?

706

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2477

---

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

688

---

Will you be able to store pictures in the database?

747

---

What is meant by raw datatype?

677

---

How do I learn what codesets are available in oracle?

655

---

List out the difference between commit, rollback, and savepoint?

711

---

What do database buffers contain?

651

---