Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    98

    Unanswered: Insert %rowtype variable into table

    is it possible to insert a %rowtype variable into a table without having to specify each column?

    eg. something like
    declare
    test_rec test_table%rowtype

    insert into test_table(test_rec)

    TIA

    MARK

  2. #2
    Join Date
    Nov 2002
    Posts
    98
    guess i will answer my own question:

    it's possible to insert a %rowtype, but only after oracle 9 release 2.

    syntax would be something like:

    insert into test_table
    values test_rec;

    notice that there is no parenthesis around.


    MARK

Posting Permissions

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