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
⇒ Retrieve the Count of Updated Rows in Oracle
⇐ Error: Exact Fetch Returns More Rows in Oracle
2018-09-13, 1526🔥, 0💬
Popular Posts:
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...