Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Re: [PL/SQL NEWBIE]Detect Varchar2 field length

Re: [PL/SQL NEWBIE]Detect Varchar2 field length

From: Catherine <catherine.devlin_at_gmail.com>
Date: 23 Nov 2004 07:09:15 -0800
Message-ID: <1101222555.033917.289210@c13g2000cwb.googlegroups.com>

Perhaps a function that will check
LENGTH(whatever) <= DATA_LENGTH
where DATA_LENGTH is queried from ALL_TAB_COLUMNS? Good luck!
- Catherine
http://profiles.yahoo.com/arcticturtle Received on Tue Nov 23 2004 - 09:09:15 CST

This message: [ Message body ]
Next message: Bagieta: "Re: ORA-00907 : missing right parenthesis"
Previous message: Alan: "Re: Getting Experience with Oracle"
In reply to: Alex NSB: "[PL/SQL NEWBIE]Detect Varchar2 field length"
Next in thread: Alex NSB: "Re: [PL/SQL NEWBIE]Detect Varchar2 field length"
Reply: Alex NSB: "Re: [PL/SQL NEWBIE]Detect Varchar2 field length"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US