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

How to retrieve the count of updated rows?

1128

What are group functions in oracle?

1043

What are the attributes of cursor?

1054

What are the restrictions on external table columns?

1054

How to connect to a local oracle 10g xe server?

992

Explain an exception and its types?

1077

How do I uninstall oracle client from windows?

1012

how do u setup a replication site?

1991

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

How to change program global area (pga) in oracle?

1096

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1053

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1736

Explain about the analyze command in oracle?

1054

State some uses of redo log files?

1012

How to use "for" statements in oracle?

1076