CREATE TABLE ACCOUNTS
( ACCOUNT_KEY VARCHAR2(20 BYTE),
LAST_NAME VARCHAR2(20 BYTE)
)
Table created.
INSERT INTO ACCOUNTS VALUES ( '1', 'AAA' );
INSERT INTO ACCOUNTS VALUES ( '2', 'ABC' );
INSERT INTO ACCOUNTS VALUES ( '3', 'BCD' );
1 row(s) inserted.
create or replace FUNCTION get_keys
RETURN SYS_REFCURSOR
IS
l_rc SYS_REFCURSOR;
BEGIN
OPEN l_rc
FOR SELECT account_key FROM accounts WHERE last_name LIKE 'A%';
RETURN l_rc;
END;
Errors: FUNCTION GET_KEYS Line/Col: 12/1 PLS-00103: Encountered the symbol "CREATE"More Details: https://docs.oracle.com/error-help/db/ora-24344
SELECT * FROM accounts WHERE account_key NOT IN ( get_keys );