CREATE TABLE A ( ID NUMBER ) NOLOGGING; INSERT /*+APPEND*/ INTO A(

Who i will insert 1 lacks record in a Database table

Question Posted / kuldeep

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;

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What happens to the indexes if a table is recovered?

938

What is private procedure oracle?

952

What are the attributes of the cursor?

930

What is analyze command used for?

1008

Why do we need integrity constraints in a database?

966

What is rowid and rownum in oracle?

951

What is a partition in oracle?

1033

What is the exact use of Collections?

2094

What is a lookup table in oracle?

928

How many types of auditing in Oracle?

977

What are the limitations oracle database 10g xe?

974

What is enter substitution variable in oracle?

979

What are advantages of dateset in datastage?

2197

How to filter out duplications in the returning rows using oracle?

989

what is Single Byte Overhead...?

2497