Oracle create type table from existing table%rowtype ?
Hi, I'm trying to create a test pipelined table function. In the first declaration then i am receiving the following error:
"Identifier LOADER.SD_DIM_DATE must be declared."
How do I create a type based on an existing object, ie a table or cursor?
create type tDateDim AS table of LOADER.SD_DIM_DATE%ROWTYPE;
/ create or replace function tvf_DateDimm
return LOADER.SD_DIM_DATE%ROWTYPE pipelined is
FOR i in (select * from LOADER.SD_DIM_DATE) loop
pipe row(I.REPORT_MONTH, I.REPORT_MONTH_DESC)
8/22/2022 - Mon
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst