SQL and PL-SQL Tutorial Apk
Apk Infos
| Version | 1.0 |
| Rating | 4.1/5, based on 227 votes |
| Size | 5.9 MB |
| Requires Android | Android 2.2+ (Froyo) |
| Author's Notes | Tutorial on SQL & PL-SQL covering all definitions & syntax with examples. |
About SQL and PL-SQL Tutorial APK
Table Of Contents
Description
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
How to install SQL and PL-SQL Tutorial APK on Android phone or tablet?
Download SQL and PL-SQL Tutorial APK file from ApkClean, then follow these steps:
Update Phone Settings
- Go to your phone Settings page
- Tap Security or Applications (varies with device)
- Check the Unknown Sources box
- Confirm with OK
Go to Downloads
- Open Downloads on your device by going to My Files or Files
- Tap the APK file you downloaded (com.ssand.app.edu.oraclesqlandplsql-v1.0-ApkClean.apk)
- Tap Install when prompted, the APK file you downloaded will be installed on your device.
Older Versions
| 1.0 (1) | 5.9 MB |
Questions & Answers
Q: What is an APK File?
A: Just like Windows (PC) systems use an .exe file for installing software, Android does the same. An APK file is the file format used for installing software on the Android operating system.
Q: If I install an APK from this website, will I be able to update the app from the Play Store?
A: Yes, absolutely. The Play Store installs APKs it downloads from Google's servers, and sideloading from a site like ApkClean.net goes through a very similar process, except you're the one performing the downloading and initiating the installation (sideloading).
As soon as the Play Store finds a version of the app newer than the one you've sideloaded, it will commence an update.
Q: Why ApkClean.net can guarantee APK 100% safe?
A: Whenever someone wants to download an APK file from ApkClean.net, we'll check the corresponding APK file on Google Play and allow user download it directly (of course, we'll cache it on our server). If the APK file does not exist on Google Play, we'll search it in our cache.
Q: What are Android App permissions?
A: Apps require access to certain systems within your device. When you install an application, you are notified of all of the permissions required to run that application.
Don't hesitate to contact us if you have any questions or concerns.
(*) is required
