Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Unanswered: time to show (more of my) ignorance

    9iDB

    Why does this work given that varchar2 are supposed to have a max definition of varchar2(4000)?

    declare
    v varchar2(30000);
    i number;
    begin
    for i in 1..3000 loop
    v := v||'1234567890';
    dbms_output.put_line(to_char(length(v)));
    end loop;

    end;
    10
    20
    .
    .
    30000
    NOTE: Please disregard the label "Senior Member".

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    VARCHAR2 has a maximum length of 32767 in PL/SQL and 4000 in tables.

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Todd, check this table to read more about Oracle datatypes and their lenghts.

Posting Permissions

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