Plsql plays, four variables, cursors, and collections are all for subsequent subroutines, including two classes, one is a function, one is a stored procedure,1) Establishing and invoking the process2) establishing and invoking functions3) Management
The syntax of plsql is different from that of tsql. For more information, see.
The syntax of plsql is different from that of tsql. For more information, see.
Insert into testtable (recordnumber, currentdate) values (I, sysdate );
Print '';
Select @
Insert into testtable (recordnumber, currentdate) values (I, sysdate );
Print '';
Select @ I = @ I + 1;
End;
After comparison, we can see that it is different.
The command structure in plsql isDelacreDefine statement segmentsBeginExecution
Explain the stored procedures of Oracle and PLSQL.1. Create a stored procedure in plsql
Open plsql, right-click procedures, and create.
If the creation is unresponsive
Direct file-New-program window-blank, create a program windowStored Procedure
Insert into testtable (recordnumber, currentdate) values (I, sysdate );Print '';Select @ I = @ I + 1;End;After comparison, we can see that it is different.The command structure in plsql isDelacreDefine statement segmentsBeginExecution statement
PLSQL programming basics, control statements, exception details, plsql programming Basics Basic PL/SQL programmingI,PL/SQL Overview1.PL/SQL Introduction
PL/SQL (Procedural Language) is a programming Language that combines with Structured Query
I. All PLSQL exceptions have the following basic features: Error Type: indicates whether the error is a ORA error or a PLS error code: a string of numbers indicating the error code error text: error message text, including error code 2, PLSQL will
Beginners can from the query to the current PL/SQL content can be found in my notes here, I hope to help everyone, video resources in resources,My own full set of notes in notesThe SQL keywords that you can continue to use in PL $ are: UPDATE Delete
Plsql:Symbol:Assignment value:: =Basic example: set serveroutput on // sets the output to open. Declare -- description section begin -- program dbms_output.put_line (' HelloWorld');
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.