Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

%ROWTYPE function

G.YFeb 15 2013 — edited Feb 15 2013
Dear all
Below is my Function code, It is compiled successfully.
create or replace
FUNCTION ITEM_DESC (ITM_CODE IMS.ITEMS.ITEM_CODE%TYPE) RETURN
IMS.ITEMS%ROWTYPE IS
REC ITEMS%ROWTYPE;
BEGIN
SELECT ITEM_DESC INTO REC
FROM IMS.ITEMS
WHERE ITEM_CODE = ITM_CODE;
RETURN REC;
EXCEPTION WHEN NO_DATA_FOUND THEN
RETURN NULL;
END;

now I want to used it in SQL query, I want to select only one coloumsn (item_description)
how it could be please guide.

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2013
Added on Feb 15 2013
3 comments
198 views