Who i will insert 1 lacks record in a Database table
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 |
Post New Answer View All Answers
What is the relationship among database, tablespace and data file?
How to delete a column in an existing table in oracle?
How to write a query with a right outer join in oracle?
What is the dynamic sql in oracle?
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'));
What is the data pump import utility?
What are the different types of failures that occur in Oracle database?
How do I reset a sequence in oracle?
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?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
Will you be able to store pictures in the database?
What is meant by raw datatype?
How do I learn what codesets are available in oracle?
List out the difference between commit, rollback, and savepoint?
What do database buffers contain?