PL/SQL learning and plsql Learning

PL/SQL learning and plsql Learning
Document 1 -- Created on
Declare
-- Local variables here
I integer;
Begin
I: = 12;
-- Test statements here
DBMS_OUTPUT.put_line (I );

End;

Document 2

Declare
Cursor s is
Select * from city_app.city_server;
S _ s % rowtype;
Begin
Open s;
Fetch s into s _;
DBMS_OUTPUT.put_line (s _. id );
Close s;
End;

How to Learn PL/SQL

Friend, the secret to learning the database language is: "back"

Of course, you also need to learn the characteristics of this language. For pl/SQL, it is unique to oracle, but you must remember that "The world is famous for Shaolin ", first, you need to find out the similarities and differences between him and his ancestor SQL and t-SQL, so that you can not only learn pl/SQL well, but also review the other two languages during the learning process, you can first find a pl/SQL grammar book, and then familiarize yourself with the content. Remember to practice it on your computer and study the computer. After you have mastered the basic syntax, you can find some projects to practice. There are many classic questions on the Internet, such as "ATM banking system" and "library management system". These questions are relatively simple, if you encounter any problems, you can go to Baidu to know and solve the problem so that you can actually improve it.

In fact, "back" is also the secret to learning all languages.

Success ^)

How to Learn pl/SQL? I only learned SQL, but it is still difficult for pl/SQL.

If I do not guess wrong, the SQL you learn should be the structured query language used in SQL Server, it is generally called Transaction-SQL (T-SQL ). The PL/SQL you want to learn is the structured query language used in Oracle.
Whether it is T-SQL or PL/SQL, their core is the same, that is, SQL, such as the United States uses ANSI-SQL as the standard of SQL, no matter which database vendor provides database products, its relational database systems should all adopt ANSI-SQL as the core, but some of their own extensions can be added, such as T-SQL and PL/SQL have their own extensions.
You already have T-SQL basics, that is to say you have a certain degree of standard SQL and T-SQL extension knowledge, learning PL/SQL, these standard SQL can continue to use, t-SQL can be used as a reference for learning PL/SQL.
The process of learning PL/SQL can be as follows, and everyone can flexibly adapt to their own needs:
(1) standard SQL;
(2) Basic PL/SQL syntax, such as operators, expressions, and control structures;
(3) Common PL/SQL packages, system functions, and views;
(4) Management of database objects, such as creating, modifying, deleting, and viewing data tables and views;
(5) data security, backup and recovery;
(6) others.