SQL and PL-SQL Tutorial icon

1.0 by Sushant Sharma


Oct 10, 2015

About SQL and PL-SQL Tutorial

Tutorial on SQL & PL-SQL covering all definitions & syntax with examples.

Complete tutorial on Oracle SQL and PL-SQL covering all definitions and syntax with examples.

Below is list of SQL and PL-SQL topics covered in the app:

SQL:-

1. Create Table

2. Alter Table

3. Rename and Drop Table

4. Insert into Table

5. Update and Delete Statements

6. Transaction Control Statements

7. SELECT Statement

8. Components of SQL Statement

9. Truncate Table

10. BETWEEN Operator

11. DISTINCT/UNIQUE

12. Character Manipulation: CONCAT

13. WHERE Clause

14. INSTR Function

15. DUAL (Dummy table)

16. SQL Functions

17. Conversion Functions

18. DECODE Function

19. Implicit & Explicit Conversion

20. Using CASE in SQL

21. NVL, NVL2 & COALESCE

22. Date Functions

23. GROUP BY Clause

24. GROUP BY Clause with Filter

25. HAVING Clause

26. Group Functions

27. SQL Joins

28. Inner Vs Outer Join

29. COMMIT-ROLLBACK Data State

30. Locking in SQL

31. MERGE Statement

32. Types of Tables

33. RR & DD Date Format

34. Pseudo-coloumns

35. SQL Constraints

36. Views & Inline Views

37. WITH CHECK OPTION in Views

38. Indexes

39. Create User and Grants

40. Synonyms

PL-SQL:-

1. PL SQL Block

2. Types of Variables

3. SQL Functions in PL-SQL

4. Conditional/Selection Control

5. Loops in PL-SQL

6. Cursors in PLSQL

7. Cursors with Parameters

8. PL-SQL Reference Cursors

9. Bulk Collect and Bulk Bind

10. PL/SQL Records Data Type

11. Composite Data Type - VARRAY

12. Composite Data Type - NESTED TABLES

13. Composite Data Type - INDEX BY TABLE

14. Implicit Exceptions

15. Explicit Exceptions

16. Exception Trapping Functions

17. PL/SQL PROCEDURE

18. PL/SQL FUNCTION

19. PL/SQL PACKAGE

20. Trigger

What's New in the Latest Version 1.0

Last updated on Oct 10, 2015

Minor bug fixes and improvements. Install or update to the newest version to check it out!

Translation Loading...

Additional APP Information

Latest Version

Request SQL and PL-SQL Tutorial Update 1.0

Uploaded by

Ý Kiến Lên Phường

Requires Android

Android 2.2+

Available on

Get SQL and PL-SQL Tutorial on Google Play

Show More

SQL and PL-SQL Tutorial Screenshots

Comment Loading...
Languages
Searching...
Subscribe to APKPure
Be the first to get access to the early release, news, and guides of the best Android games and apps.
No thanks
Sign Up
Subscribed Successfully!
You're now subscribed to APKPure.
Subscribe to APKPure
Be the first to get access to the early release, news, and guides of the best Android games and apps.
No thanks
Sign Up
Success!
You're now subscribed to our newsletter.