Exforsys

Free Training

Insertion of multiple values using a single insert statement in oracle 10g

This is a discussion on Insertion of multiple values using a single insert statement in oracle 10g within the Oracle Tutorials forums, part of the Articles and Tutorials category; Hey i am trying to insert multiple values in a table using a single insert into statement.I just wanted to ...

Go Back   Exforsys > Articles and Tutorials > Oracle Tutorials

Exforsys.com


Oracle Tutorials Oracle Tutorials and Articles Discussions

Reply

 

LinkBack Thread Tools Search this Thread
  #1 (permalink)  
Old 09-16-2008, 10:29 PM
Junior Member
 
Join Date: Sep 2008
Posts: 1
simplyshravan is on a distinguished road
Insertion of multiple values using a single insert statement in oracle 10g

Hey i am trying to insert multiple values in a table using a single insert into statement.I just wanted to avoid writing multiple insert into statements for entering data into a table.Is there any way i can do this.

I tried this way

create table ike
(Name varchar(25),
age number(3),
phn number(10),
salary number(9,2));

i created this table and tried unserting values

insert into ike('&name',&age,&phn,&salary);
Enter value for name:
Enter value for age:
Enter value for phn:
Enter value for salary:
When i entered the values it read an error message
Error at line 2
ORA 00928:missing Select keyword in line 1.

i then tried to enter agai by using backslash(/)
SQL>/
but it showed me the same error..
could any 1 make out a point of this...

I have seen a post about this here but i could'nt find it now.
Thanx in advance

Last edited by simplyshravan; 09-16-2008 at 10:33 PM. Reason: Made my doubt more cleared to the viewers
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 09-19-2008, 01:31 AM
Junior Member
 
Join Date: Sep 2008
Posts: 2
oraclegeek is on a distinguished road
You can trying insert into (select statement) to load the data; can you be more specific
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
QTP Material kalyansantosh Software Testing 6 03-05-2009 05:13 AM
Oracle Enterprise Single Sign-On Write-Up JaySan Oracle Tutorials 0 02-11-2008 06:32 PM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit Tech FAQ 0 06-01-2004 07:00 AM
Solaris x86 FAQ 2/2 Dan Anderson Tech FAQ 0 04-27-2004 08:24 PM
[FAQ] FileMaker Pro - database for Macintosh and Windows Martin Trautmann Tech FAQ 0 04-17-2004 08:26 AM


All times are GMT -4. The time now is 12:07 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.0
Copyright 2004 - 2009 Exforsys Inc. All rights reserved.