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 ...
|
|||||||
|
|||
|
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 |
| Sponsored Links |
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
|
|
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 |