[program-l] Re: Oracle SQL question
- From: "Homme, James" <james.homme@xxxxxxxxxxxx>
- To: "program-l@xxxxxxxxxxxxx" <program-l@xxxxxxxxxxxxx>
- Date: Tue, 1 Sep 2009 06:58:14 -0400
Hi,
What does the document look like?
Jim
----------
Jim Homme
Usability Services
412-544-1810
james.homme@xxxxxxxxxxxx
"Strength does not come from physical capacity. It comes from an indomitable
will." -- Mahatma Gandhi
-----Original Message-----
From: program-l-bounce@xxxxxxxxxxxxx [mailto:program-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Lafond, Eileen
Sent: Monday, August 31, 2009 4:47 PM
To: program-l@xxxxxxxxxxxxx
Subject: [program-l] Re: Oracle SQL question
Hi,
I forgot to say that the names of the employees to be added are in a Word
document and not on an Oracle table.
Thanks,
Eileen La Fond
Phone (206) 386-0011
e.mail Eileen.LaFond@xxxxxxxxxxx
-----Original Message-----
From: program-l-bounce@xxxxxxxxxxxxx [mailto:program-l-bounce@xxxxxxxxxxxxx] On
Behalf Of James Homme
Sent: Monday, August 31, 2009 11:51 AM
To: program-l@xxxxxxxxxxxxx; Lafond, Eileen
Subject: [program-l] Re: Oracle SQL question
Hi,
I forget the syntax, but you can do this with a pl/sql loop.
Jim
----------
Jim Homme
Usability Services
412-544-1810
james.homme@xxxxxxxxxxxx
"Strength does not come from physical capacity. It comes from an indomitable
will." -- Mahatma Gandhi
-----Original Message-----
From: program-l-bounce@xxxxxxxxxxxxx [mailto:program-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Lafond, Eileen
Sent: Monday, August 31, 2009 12:18 PM
To: program-l@xxxxxxxxxxxxx
Subject: [program-l] Oracle SQL question
Hi,
I need to insert forty rows into a table. I know how to insert one row as per
the skeleton script below, but is there a way to be able easily to insert
multiple rows at one time instead of using the below script forty times?
Code follows:
Insert into making_connections
(first_name,
middle_name,
last_name,
Date_article,
article)
values
('',
'',
'',
'',
'This is a test article
');
Eileen La Fond
Phone number: (206) 386-0011
EMail: eileen.lafond@xxxxxxxxxxx
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
This e-mail and any attachments to it are confidential and are intended solely
for use of the individual or entity to whom they are addressed. If you have
received this e-mail in error, please notify the sender immediately and then
delete it. If you are not the intended recipient, you must not keep, use,
disclose, copy or distribute this e-mail without the author's prior permission.
The views expressed in this e-mail message do not necessarily represent the
views of Highmark Inc., its subsidiaries, or affiliates.
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
This e-mail and any attachments to it are confidential and are intended solely
for use of the individual or entity to whom they are addressed. If you have
received this e-mail in error, please notify the sender immediately and then
delete it. If you are not the intended recipient, you must not keep, use,
disclose, copy or distribute this e-mail without the author's prior permission.
The views expressed in this e-mail message do not necessarily represent the
views of Highmark Inc., its subsidiaries, or affiliates.
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
