Top "Rowtype" questions

Oracle: Insert rowtype data into another table

I have one table called event, and created another global temp table tmp_event with the same columns and definition …

oracle plsql insert rowtype

Using Oracle PL/SQL table of record with multiple %rowtype fields

How can I populate a table of records which has more than one field of %rowtype using bulk collect? my …

oracle plsql record rowtype bulk-collect

how to declare %ROWTYPE of a variable that is a weakly typed SYS_REFCURSOR?

W.r.t code below I can not declare the type of fetch-into-variable as the underlying table's %ROWTYPE because the …

oracle stored-procedures plsql sys-refcursor rowtype

PL / SQL Function to return varchar2 / numbers

I have this PL / SQL function that accepts the name of a student (f_name). The function then displays all …

sql oracle plsql rowtype

Returning a Custom Type from a Postgresql function

I'm trying to return a Custom type from a PostgreSQL function as follows: DROP TYPE IF EXISTS GaugeSummary_GetDateRangeForGauge_Type …

postgresql types rowtype

while executing below code it showing error

This is my pl/sql program: declare m_no emp.emp_no%rowtype; m_name emp.emp_name%rowtype; m_…

plsql cursor rowtype

how to pass a table name as parameter to stored procedure?

Is it possible to create a rowtype for a table name which is passed as a parameter to a Stored-Procedure …

oracle stored-procedures plsql rowtype

How to select the row table data in pl/sql

Please help. I tried this, I don't know how to proceed. I need to give a select into statement for …

oracle plsql declare rowtype