Re: Oracle case senseitivity??
From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/11/20
Message-ID: <56uqtp$20p_at_newton.pacific.net.sg>#1/1
Date: 1996/11/20
Message-ID: <56uqtp$20p_at_newton.pacific.net.sg>#1/1
Greg Clark <gregc_at_qualatex.com> wrote:
>We are building our first PB app and Oracle db. Our question is, if we
>mix case in nameing db columns will oracle require our app or other
>reporting tools to use the correct case mixture?
Hi there
Within Oracle dictionary, all the database objects are stored in upper case. For example if you create a table called 'emp'. then it is stored in UPPER case.
Normally ORACLE is case in-sensitive as far data dictionary is concerned. You can reference 'emp' table as EMP, emp, Emp.
Regards
N.Prabhakar Received on Wed Nov 20 1996 - 00:00:00 CET