FAQ
--
EMPLOYEE table ( no constraints defined) has currently 1000 records.
How to insert extra 100 Records based on one existing record and change
EMPNAME column only based on the List of 100 EMPNAMES i have ?--
--
Thanks for any and all ideas.

Bala Rao

--
http://www.freelists.org/webpage/oracle-l

Search Discussions

  • Richard J. Goulet at May 17, 2007 at 4:19 pm
    Sounds like a job for a good text editor. May I suggest Ultraedit from
    www.idmcomp.com.


    Dick Goulet / Capgemini
    North America P&C / East Business Unit
    \Senior Oracle DBA / Outsourcing
    Office: 508.572.1978 / Mobile: 508.742.5795 / www.capgemini.com
    <http://www.capgemini.com/>
    Fax: 508.229.2019 Email: richard.goulet_at_capgemini.com
    45 Bartlett St. / Marlborough, MA 01752

    Together: the Collaborative Business Experience



    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Bala
    Sent: Thursday, May 17, 2007 11:13 AM
    To: oracle-l
    Subject: SQL Insert question

    --
    EMPLOYEE table ( no constraints defined) has currently 1000 records.
    How to insert extra 100 Records based on one existing record and change
    EMPNAME column only based on the List of 100 EMPNAMES i have ?--
    --
    Thanks for any and all ideas.

    Bala Rao

    --
    http://www.freelists.org/webpage/oracle-l
  • Don Seiler at May 17, 2007 at 5:17 pm
    Look up the MERGE statement.

    Don.
    On 5/17/07, Bala wrote:
    --
    EMPLOYEE table ( no constraints defined) has currently 1000 records.
    How to insert extra 100 Records based on one existing record and change
    EMPNAME column only based on the List of 100 EMPNAMES i have ?--
    --
    Thanks for any and all ideas.

    Bala Rao
    --
    Don Seiler
    oracle blog: http://ora.seiler.us
    ultimate: http://www.mufc.us
    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 17, '07 at 3:13p
activeMay 17, '07 at 5:17p
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase