Hi,
DECLARE
TYPE EmpTabTyp IS TABLE OF orders%ROWTYPE;
emp_tab EmpTabTyp := EmpTabTyp(NULL); --initialization
BEGIN
SELECT * INTO emp_tab(5)
FROM orders--;
WHERE order_id = 'o-001';
END;
Order table structure
ORDER_ID VARCHAR2(10 BYTE)
PROD_ID VARCHAR2(10 BYTE)
PRODUCT_CATEGORY VARCHAR2(50 BYTE)
ORDER_DATE DATE
QTY NUMBER(38,0)
I am filtering with single row only, ex- o-001 record but i am getting error