Oracle's modulation method in SQL * Plus

xiaoxiao2021-03-06  90

In SQL * PLUS, the function / process call method: - Description: Key_barcode () is the built function, the parameter is m_no in char, sq in char, pt in char, nkey is the return value. - p_key_barcode () The established process, the parameter is m_no in char, sq in char, pt in char, maxkey in out number.1.variable nkey number; execute: nkey: = key_barcode ('99A99A', '03', 'L'); Set ServerOutput on; Execute DBMS_OUTPUT.PUT_LINE (: NKEY);

2.Set ServerOutput on; Execute DBMS_OUTPUT.PUT_LINE (Key_Barcode ('99A99A', '03', 'L'));

3.Variable Nkey Number; Call Key_barcode ('99A99A', '03', 'L') INTO: NKEY; - Process: Call Key_Barcode ('99A99A', '03', 'L') Note: Call belongs to SQL statements , Invalid in PL / SQL

4.Select Key_Barcode ('99A99A', '03', 'L') from Dual; Note: Insert, Update, DML statement of INSERT, UPDATE, DELETE, in the SELECT statement, if used: ORA-14551: Unable Perform a DML operation error in the query.

5. (Procedure) Variable Nkey Number; Execute P_key_barcode ('99A99A', '03', 'L',: NKEY);

转载请注明原文地址:https://www.9cbs.com/read-123063.html

New Post(0)