%datatype [message #38332] |
Thu, 11 April 2002 02:34 |
debichowdhuri
Messages: 2 Registered: March 2002
|
Junior Member |
|
|
Can u pls tell me if there is any performance issues in using table.cloumnname%type. i mean does it check everytime at runtime the database field and does it make the system slow.
|
|
|
Re: %datatype [message #38333 is a reply to message #38332] |
Thu, 11 April 2002 04:34 |
Epe
Messages: 99 Registered: March 2002
|
Member |
|
|
Hello,
it does change at runtime into the correct datatype, but I've never noticed it slowing down the program.
Cheers,
epe
|
|
|
|
Re: %datatype [message #38354 is a reply to message #38332] |
Fri, 12 April 2002 23:13 |
Eric
Messages: 78 Registered: April 1999
|
Member |
|
|
It does not slow down performance at all.
I swear by that technique and scorn anyone who does NOT use it.
If your code has varchar2(30) and
the column length increases to 50 later on, your program will bomb(at runtime) and believe it or not, it may not be that easy to find.
Trust me on this. I went thru it more than once.
|
|
|