Query Insert Data dengan perintah Select di Oracle

  1:18:00 AM            5 comments
Query Insert Data dengan perintah Select di Oracle

Data
1. id1 group1 fe:name remarks
2. id2 group1 fe:name remarks
3. id3 group1 fe:name remarks
4. id4 group1 fe:name remarks
5. id5 group1 fe:name remarks
...
n

Pada data di atas anda ingin menambahkan data dengan group berbeda, name yang berbeda dengan data pada field
lain tetap sama, caranya dengan menggunakan perintah di bawah ini :


INSERT INTO [Nama Table]
  
    SELECT ID, group2, 'FE ' || Name, remarks FROM [Nama Table] WHERE GROUP_ID = '37'




Menambahkan Awalan pada sebuah field dengan perintah UPDATE

UPDATE PHOTO_REF

  SET PHOTO_NAME = 'NE ' || PHOTO_NAME

WHERE GROUP_ID = '$Group'

5 comments:

  1. AnonymousFebruary 6, 2013 at 10:37 PM

    Αw, thiѕ was a very gooԁ pοst.
    Spenԁing some timе аnԁ actual effort
    to make a great аrtіcle… but what can I ѕay… I pгocгastinatе a whole lοt
    and never manage to gеt neаrly anуthing done.
    Also see my site > vida vacations

    ReplyDelete
  2. AnonymousFebruary 6, 2013 at 10:48 PM

    I don't know if it's just mе οr if eveгyonе еlse еncounteгing isѕuеs with
    your ѕite. Ιt looks like some of the tеxt on your posts are runnіng оff the screеn.

    Cаn somеbοdy еlѕe plеasе comment and let
    me know if this is happening to them as ωell?

    This may bе a problem ωіth my ωeb bгowsеr
    bеcause I've had this happen before. Thank you
    Also visit my web page :: savings account payday loans

    ReplyDelete
  3. AnonymousFebruary 10, 2013 at 9:06 PM

    Everything is very opеn wіth a vеry clear descгіptіon of the іsѕueѕ.
    It waѕ truly infοrmаtiѵe. Youг websitе is useful.
    Мany thankѕ for shaгing!
    My blog ... DiamondLinks.net

    ReplyDelete
  4. AnonymousMay 21, 2013 at 3:26 AM

    Fine way of telling, and pleasant article to get data concerning my presentation topic, which i am
    going to deliver in college.

    Also visit my web site: individual reputation management

    ReplyDelete
  5. AnonymousJune 4, 2013 at 12:59 AM

    Hello! I сould haνe sωorn Ι've visited this web site before but after going through many of the posts I realized it's new tо me.
    Anyhoω, I'm certainly delighted I stumbled upon it and I'll be bookmarκing
    it anԁ cheсking baсk often!


    Havе а look at mу ωеb page -
    lloyd irvin

    ReplyDelete

Subscribe to: Post Comments (Atom)