Home » SQL & PL/SQL » SQL & PL/SQL » %datatype
%datatype [message #38332] Thu, 11 April 2002 02:34 Go to next message
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 Go to previous messageGo to next message
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
%datatype & %type are resolved once at compile/parse time [message #38338 is a reply to message #38332] Thu, 11 April 2002 22:18 Go to previous messageGo to next message
Elic
Messages: 3
Registered: April 2002
Junior Member
%datatype & %type are resolved once at compile/parse time
Re: %datatype [message #38354 is a reply to message #38332] Fri, 12 April 2002 23:13 Go to previous message
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.
Previous Topic: How to obtain Rows affected in PL/SQL???
Next Topic: BULK COLLECT AND TABLE JOINS.. please help!!
Goto Forum:
  


Current Time: Thu Mar 28 23:47:23 CDT 2024