Ho to insert no. of records at a time..i mean i want to
insert 100 records at a time into a table
Answer Posted / selvaraj v
In oracle 10g :
---------------->
Step 1 : SQL> CREATE TABLE identity( ID NUMBER);
Step2 : Write a Simple Procedure for to insert values into
table.
DECLARE
i NUMBER;
BEGIN
FOR i IN 1..100 LOOP
INSERT INTO identity VALUES(i);
END LOOP;
END;
/
PL/SQL procedure successfully completed.
Step 3 : SELECT COUNT(*) FROM identity;
COUNT(*)
----------
100
Please check it. Works fine.
PL/SQL procedure successfully completed.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the use of record length option in exp command.
Difference between the “verify” and “feedback” command?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
List out the components of logical database structure of oracle database.
What are the built-in functions used for sending Parameters to forms ?
what is the scenario where you take the database to NoArchivelog mode?
How to call a sub procedure?
What is transaction control statement and how many types of transaction control statement in Oracle?
What is translate in oracle?
How translate command is different from replace?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is the maximum limit on the number of columns in a table?
What happens if recursive calls get out of control?
How do I limit the number of oracle database connections generated by weblogic server?
1) Does oracle have any table which contain all the exceptions and it's code internally?