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

Can we save images in a database and if yes, how?

1108

What is the database name in oracle?

1076

Differentiate between pre-select and pre-query?

1153

What are the uses of synonyms?

1183

how to do daily transactions with out sql* loader control file regesterd in apps?

1727

Can you drop an index associated with a unique or primary key constraint?

1067

what is the scripts in data base?

2217

How to save query output to a local file?

1082

How to Truncate Table in Oracle

1210

What is bulk collect in oracle?

1052

What do you understand by database schema and what does it hold?

1297

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2144

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2202

What is Library Cache in Oracle?

1185

How to create lov dynamically at runtime & attach to text field?

1238