Interested to Buy Any Domain ? << Click Here >> for more details...
Who i will insert 1 lacks record in a Database table
- 4 Answers
- 12864 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / milan
The qs is not quite clear....
Still I suppose u wana insert 1 lach record in database
table.
It is quite simple....
Just write a stored procedure for insert of 1 lakh
records,compile it and run...
U will b get 1 lakh records inserted in a single stroke...
| Is This Answer Correct ? | 3 Yes | 3 No |
How to create a new user account in oracle?
What is Segment Advisor in Oracle?
what are the disadvantages of hierarchial database over RDBMS?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
What is ADDM Advisor in Oracle?
Explain the use of file option in exp command.
What is a database table in oracle?
definition of cluster and non-clustered index?
Please explain drop constraint oracle?
What is the difference between 10g OEM and 11g OEM?
Is there an oracle sql query that aggregates multiple rows into one row?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
Oracle General 
