Collections:
Invoke Built-in Functions in PL/SQL in Oracle
How To Invoke Built-in Functions in PL/SQL in Oracle?
✍: FYIcenter.com
Of course, you can invoke SQL functions in SQL statements. But many SQL functions can also be executed in regular PL/SQL statements, as shown in the following sample script:
DECLARE now DATE; id NUMBER; str VARCHAR2(40); BEGIN now := SYSDATE; DBMS_OUTPUT.PUT_LINE('Time #1 = ' || TO_CHAR(now,'HH24:MI:SS')); SELECT SYSDATE INTO now FROM DUAL; DBMS_OUTPUT.PUT_LINE('Time #2 = ' || TO_CHAR(now,'HH24:MI:SS')); id := UID; DBMS_OUTPUT.PUT_LINE('User id #2 = ' || TO_CHAR(id)); SELECT UID INTO id FROM DUAL; DBMS_OUTPUT.PUT_LINE('User id #2 = ' || TO_CHAR(id)); str := CHR(70)||CHR(89)||CHR(73); DBMS_OUTPUT.PUT_LINE('String #1 = ' || str); SELECT CHR(70)||CHR(89)||CHR(73) INTO str FROM DUAL; DBMS_OUTPUT.PUT_LINE('String #2 = ' || str); END; / Time #1 = 21:41:16 Time #2 = 21:41:16 User id #2 = 33 User id #2 = 33 String #1 = FYI String #2 = FYI
2018-09-13, 850👍, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Concatenate Two Text Values in Oracle? There are two ways to concatenate two text values toge...
How To Create a Test Table for Transaction Testing in Oracle? If you want to practice DML statements...