Cursor myCur is
Select * from M_CUST where rownum & lt;=1;
OneRow M_CUST % rowtype;
The begin
The open myCur;
Loop
The fetch myCur
Into oneRow;
Dbms_output. Put_line (oneRow cd_cust | | oneRow. Nm_cust);
/*
How the value of the column in the dynamic traversal % rowtype
The for loop to print out all column values
Dbms_output. Put_line (oneRow. Dynamic column names? ;
*/
Exit the when myCur % notFound;
End loop;
The close myCur;
end;
CodePudding user response:
CodePudding user response:
DBMS_SQL package can achieve your requirements, baidu should have some example,