Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Michigan/Pennsylvania
    Posts
    4

    Unanswered: insert to/select from queries with VARCHARs and CLOBs

    Good evening..

    Does anyone know if you can do INSERT INTO x (clob_column) SELECT varchar_column FROM y? And vice versa?

    Thanks much.

    -Julie

  2. #2
    Join Date
    Dec 2002
    Posts
    134

    Re: insert to/select from queries with VARCHARs and CLOBs

    why not, just make sure the data will fit into the target column

    create table test (cl clob (10k) compact not logged, vc varchar(1000))
    ;
    insert into test values ('clob', 'varchar')
    ;
    select * from test
    ;
    update test set cl =vc, vc = cl
    ;
    select * from test
    ;

Posting Permissions

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