Help - Search - Members - Calendar
Full Version: Deciding on %type and %rowtype
Oracle DBA Forums > Oracle > Oracle Forum
testoracle
How to decide between %type and %rowtype in the following scenario:- I have 1 table with 60 columns and out of them, 40 are not used in stored procedure. Does %rowtype take a lot of memory in that case or is it better to use it?
SteveC
I would probably go with table.column%type (anchored) for two reasons. One is that you are dealing with the minority and the other is for documenting the columns used in the procedure. With %rowtype, you will still have to know the columns if you are only using a subset of them for other DML.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.