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

Home -> Community -> Usenet -> c.d.o.server -> Re: column prefixes

Re: column prefixes

From: T. M. Gray <tgray_at_siri.com>
Date: 1998/02/21
Message-ID: <6cn57q$5ov$1@usenet48.supernews.com>#1/1

I know CASE method likes it, but the idea of attributes/columns is that they have meaning within the context of the entity/table which contains them....not to mention it's toooooooo much typing! suhasu_at_hotmail.com wrote in message <6ckme4$kn3$1_at_nnrp1.dejanews.com>...
>Hi,
>
>Are there any pros/cons to having table identifying
>prefixes to column names???
>
>I have seen database applications where the column names in a
>table have a 2-4 letter prefix distinguishing similar column
>entities in different tables.
>Eg.
>EMPLOYEE Table
>em_employee_code (code of the employee)
>em_employee_name (name of the employee)
>em_dept_code (department code for the employee)
>em_create_date (timestamp)
>
>DEPARTMENT Table
>de_dept_code (code for department)
>de_dept_name (name for department)
>de_create_date (timestamp)
>
>Thus for a sql to obtain all employees working for
>departments whose name begins with 'SOC' we will have
>
>SELECT distinct em_employee_code
>FROM employee, department
>where em_dept_code = de_dept_code
>and de_dept_name = 'SOC%';
>
>I would rather like to use this concept but need strong
>evidences in support of it.
>Thanks in advance,
>Suhas
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Sat Feb 21 1998 - 00:00:00 CST

Original text of this message

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