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: Would be really nice if...

Re: Would be really nice if...

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sat, 26 Feb 2005 13:10:37 -0500
Message-ID: <LfidncDJJ686Jr3fRVn-rQ@comcast.com>

"Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message news:cvq6es$d6m$1_at_news2.zwoll1.ov.home.nl...
> Jaap W. van Dijk wrote:

>> On Thu, 24 Feb 2005 14:50:11 +0100, Frank van Bortel
>> <fvanbortel_at_netscape.net> wrote:
>>
>>
>>>kirtan wrote:
>>>
>>>>Using the same logic,
>>>>'select * from t' would also break any application if an alter table
>>>>has been done to it.
>>>>This would happen where the columns are being retrieved by position and
>>>>not by name.
>>>>But ain't this feature still there?!
>>>>
>>>
>>>Correct - it is known as A Bad Habit (tm).
>>>ROT: Always specify the column list.
>>
>>
>> As a ROT I agree, but I happily code the following in PL/SQL for a
>> table with a lot of columns:
>>
>> cursor c_cur is select * from tabble;
>> r_cur c_cur%rowtype;
>>
>> and use r_cur everywhere it is needed.
>

> And do what? You would still need r_cur.[column_name]
> to access a particular column / value.
> Surely you do not use r_cur in an insert...
> --
> Regards,
> Frank van Bortel

unless it's an object table, no?

++ mcs Received on Sat Feb 26 2005 - 12:10:37 CST

Original text of this message

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