Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: BYTE OR CHAR LENGTH Semantics

Re: BYTE OR CHAR LENGTH Semantics

From: Michael Garfield Sørensen <mgs_at_CeDeT.dk>
Date: Mon, 21 May 2007 14:41:59 +0200
Message-ID: <20070521144159.45pfs5d0ysgw0g4w@farina.netsite.dk>

  1. Do a describe in SQL*Plus

or

B) Look in the CHAR_USED column of user_tab_columns (C=Char,B=Byte)

HTH
Michael
Oracle Developer

Quoting DBA Deepak <oracle.tutorials_at_gmail.com>:

> Hi Gurus,
>
> How to know whether a table column has been create using BYTE or CHAR length
> semantics?
>
>
> --
> Regards,
>
> Deepak
> Oracle DBA

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 21 2007 - 07:41:59 CDT

Original text of this message

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