Results 1 to 2 of 2

Thread: select into statement in Oracle?.

  1. 01-31-2003, 04:28 PM #1
    ravi
    ravi is offline Registered User
    Join Date
    Nov 2002
    Posts
    231

    select into statement in Oracle?.

    Hi,
    Anybody give example in ORACLE for below sql server statement.
    Thanks,
    Ravi

    select a, b into temp_table
    from old_table
    Reply With Quote Reply With Quote
  2. 01-31-2003, 04:34 PM #2
    JBane
    JBane is offline Registered User
    Join Date
    Dec 2002
    Posts
    181
    Long ago, but I believe its:

    CREATE TABLE NewTable AS
    SELECT (your statement)


    Jeff
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules