Re: Generating SQL

From: Otavio C. Decio (REMOVEodecio_at_earthlink.REMOVE.net)
Date: 11/18/04 

Date: Thu, 18 Nov 2004 17:31:48 -0500

"Mikito Harakiri" <mikharakiri_nospaum@yahoo.com> wrote in message
news:8a529bb.0411181353.7855a736@posting.google.com...
> "Otavio C. Decio" <REMOVEodecio@earthlink.REMOVE.net> wrote in message
news:<R_Kdndy4suEVEAHcRVn-jw@giganews.com>...
>
> create table emp (
> empno integer,
> ename string
> )
>
> insert into emp (empno, ename)
> values (500, 'Jon Doe');
>
> select ename from emp
> where empno = 500
>
> alter table emp
> add sal integer
>
> Now the query and insert statement still work. The suggestion that
> application developers have to rewrite any sql statements whenever db
> designer adds a column is ridiculous.

Ok, wise guy. Why did you add a column if you're not going to use it?

Otavio

Relevant Pages

  • Re: Generating SQL
    ... >> empno integer, ... >> select ename from emp ... >> application developers have to rewrite any sql statements whenever db ...
    (comp.object)
  • Re: Generating SQL
    ... insert into emp (empno, ename) ... application developers have to rewrite any sql statements whenever db ...
    (comp.object)
  • OCI-8, Oracle : ORDER BY doesnt work with bind_param
    ... I play with the user SCOTT and the table EMP of ... Schema = SCOTT, Name =EMP Columns8 ... ENAME' the result is good. ... # Request with 3 parameters. ...
    (comp.lang.ruby)
  • add a column specified location in Table..
    ... i have a table emp,it has three fields one is empno int,second is ... ename varchar. ... i dont want a add last only, i want to add a column only between ...
    (comp.databases.ms-sqlserver)
  • Re: SQL: How Many Diff JOBs for each ENAME
    ... many employees in EMP and ENAME is not unique of course..... ... How to find HOW MANY DIFFERENT JOBs for each ENAME (non-key) ...
    (comp.databases.oracle.server)