how to develop Oracle pl/sql knowledge
(chennai, tamilnadu, India)
I need to develop my skill in Oracle pl/sql in depth my total IT experience 4.2 years. Can you help?
If you have any programming experience at all then Oracle PL/SQL is quite easy to learn as the concepts underlying the language are the same as most other high-level programming languages. PL/SQL is based on a language call Ada which is named after Ada, Countess of Lovelace, a 19th century English mathematician and writer who worked with Charles Babbage on his Analytical Engine.
The language Ada is in turn based on the programming language Pascal (named after the 17th
century French mathematician Blaise Pascal) which was created by Niklaus Wirth in the late 1960s. Pascal is a small, efficient and highly structured language that is designed to help students learn programming.
This makes Oracle PL/SQL an easy to use, high level, block-structured programming language and despite being based on a language from the 20th century is advanced enough and flexible enough to be used still by many organisations around the world (including Oracle themselves) to build large and complex applications. If you're used to C, C++, C# or Java you might find the syntax a little strange initially as, in particular, the assignment
operator "=" in C is the equivalence operator in PL/SQL (i.e. it is used to check if 2 values are the same).
Oracle's customers have questioned in the past whether PL/SQL will continue to be supported in future releases of the database or whether it will be phased out in favour of Java but Oracle have stated that they have no plans to deprecate PL/SQL and continue to enhance the language with every new release of the database (including Oracle Database 12c).
In summary, Oracle PL/SQL is an efficient, high level, block-structured language which has been designed by Oracle to integrate easily with SQL and therefore with the database.
To learn PL/SQL follow the series of Oracle PL/SQL tutorials
on our site. These tutorials cover the following topics amongst others:
- what is PL/SQL?
- language elements
- integration of PL/SQL with Oracle databases and SQL?
- What are the 7 worst coding crimes you can commit in PL/SQL?
- What are the top myths about PLSQL performance?
You might also be interested in the following questions and answers:
and in our Oracle tutorials
See our Oracle training
page for information about formal training in PL/SQL.