Who i will insert 1 lacks record in a Database table
- 4 Answers
- 13082 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 many categories of data types in oracle?
Can a Tablespace hold objects from different Schemes ?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What are the different windows events activated at runtime ?
what is load balancing and what u have used to do this?(sql loader)
Can objects of the same schema reside in different tablespace?
What does COMMIT do ?
How to define an anonymous block?
What is truncate oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is partitioned table in Oracle?
Oracle General 
