Complete tutorial on Oracle SQL and PL/SQL covering all definitions and syntax with examples. This tutorials will help you to learn basic SQL and PL/SQL programming language and help you to understand the designing of database. SQL and PL/SQL topics are covered in this tutorial.
SQL Topics :
SQL-Introduction SQL-Database SQL-RDBMS concept SQL-Syntax SQL-Data types SQL-Operators SQL-Expressions SQL-Create database SQL-Drop database SQL-Create table SQL-Drop table SQL-Alter table SQL-Truncate table SQL-Insert statement SQL-Select statement SQL-Where clause SQL-AND & OR clause SQL-Update statement SQL-Delete statement SQL-Like operator SQL-Order by clause SQL-Group by clause SQL-Distinct keyword SQL-Min and Max function SQL-Count, Avg and Sum function SQL-Constraints SQL-Alias SQL-Wildcards SQL-Date function SQL-Null value SQL-Sub queries SQL-Join SQL-Index SQL-View SQL-Having clause SQL-Transactions SQL-Sequence SQL-Duplicate handling
PL/SQL Topics :
PL/SQL-Basic Syntax PL/SQL-Data Types PL/SQL-Variables PL/SQL-Constant and Literals PL/SQL-Operators PL/SQL-Conditions PL/SQL-Loops PL/SQL-Strings PL/SQL-Arrays PL/SQL-Procedures PL/SQL-Functions PL/SQL-Cursors PL/SQL-Records PL/SQL-Exceptions PL/SQL-Triggers PL/SQL-Packages PL/SQL-Collections PL/SQL-Transactions PL/SQL-Date and Time
Features of SQL & PL/SQL App: 1. SQL & PL/SQL include in one app. 3. User Interface (UI) well designed.
Comments will not be approved to be posted if they are SPAM, abusive, off-topic, use profanity, contain a personal attack, or promote hate of any kind.