價格：免費
更新日期：2019-04-18
檔案大小：2.7M
目前版本：2.0
版本需求：Android 4.0.3 以上版本
官方網站：http://oracleplsqlblog.com/
Email：rushi.p.mashru@gmail.com
聯絡地址：303, 3rd Floor Gokuldham Apartment, Near Lal Palace, Chowpatty Road, Porbandar, Gujarat 360575 India
Want to learn Oracle SQL and Oracle PL/SQL programming? Then this is the perfect application for you. If you are a beginner or an experienced professional, this application will help you brush up your SQL and Oracle PL/SQL skills and learn complex topics with easy examples.
We bring out the most interesting and important topics from the technology and explain them with a beginner to expert approach, lots of our tutorials helps you to understand and solve complex SQL queries and PL/SQL problems sets in more than one way, through this approach you can develop a keen sense of understanding of a problem and various routes that you can take to solve them.
Database is one of the most important subject in any Computer Science syllabus, and it’s a backbone of our Software world, be it any RDBMS systems like Oracle, MS SQL Server, Postgres or MySQL. Though these databases are very different from each other and follow some unique architecture, they have something in common and that is, all the follow RDBMS rules and pass the ACID test.
Also, the language used to interact with these databases is SQL or Structured Query Language which has become a standard of the ANSI in 1986. SQL helps us in designing and managing data held in a RDBMS system.
In this APP we will concentrate on the ANSI SQL, so that users can learn and use them with multiple databases with minimal changes, and we would also explain concepts of Oracle PL/SQL which an extension to SQL and some proprietary concepts and syntax of Oracle SQL is.
The topics that are discussed in depth are:
Oracle SQL:
CREATE TABLE
ALTER TABLE
DATATYPES
CHAR
VARCHAR2
GLOBAL TEMPORARY TABLES
PRIMARY KEY and FOREIGN KEY
VIEWS
DELETE
TRUNCATE
IN, NOT IN
EXISTS, NOT EXISTS
FLASHBACK
GROUP BY AND HAVING CLAUSE
MATERIALIZED VIEWS
ADVANTAGES OF MATERIALIZED VIEWS
CASE STATEMENT
DECODE STATEMENT
NVL, NVL2, NULLIF, LNNVL, COALESCE
HIGH WATER MARK
INDEXES
TYPES OF JOINS
MERGE STATEMENT
ROW_NUMBER
ROWID
RANK, DENSE_RANK
SQUENCE
SQL LOADER
CREATE USER
DROP USER
ACCOUNT UNLOCK
PASSWORD RESET
UNION AND UNION ALL
HEIRARCHICAL QUERIES
START WITH , CONNECT BY CLAUSE
Oracle PL/SQL
PL/SQL BLOCKS
PROCEDURES
FUNCTIONS
TYPE OF EXCEPTIONS
EXCEPTION HANDLING
ERRORS, SQLCODE AND SQLERRM
DIFFERENCE BETWEEN PROCEDURES AND FUNCTIONS
WRAPPERS
BULKCOLLECT
Interview Questions:
HOW TO REMOVE DUPLICATES FROM A TABLE
CHANDING ROWS TO COLUMNS, PIVOT AND UNPIVOT
RECORDS
SYS REF CURSORS
SELECT ODD / EVEN ROWS
PALINDROM NUMBER
FACTORIAL
We keep on updating our content and keep on adding topics every now and then, so make sure to download the app and learn.
Video & Blog Content:
The videos are used to explain topics more practically. These videos are owned and developed by us and we reserve its copy right.
You can follow us and subscribe our YouTube channel i.e. Kishan Mashru’s channel https://www.youtube.com/channel/UCxG8X3oiBsqTKFhrk53AfXw
You can visit our website i.e. http://oracleplsqlblog.com too. We strive to provide best knowledge on various topics related to DBMS, SQL, Pl/SQL, Oracle Database and so more.
Disclaimer: **Legal Notices:
This is NOT an official, but a fun made application. All the logos, trademarks and sources are the properties of their respective owners. If there is any issue, kindly send us an email with full details.
There is no copyright infringement intended, If you are the copyright holder of the images this application and do not want your image displayed, please contact us via email and tell us about the status of your ownership over it. We will be happy to resolve any issues.
Privacy Policy of the application: http://oracleplsqlblog.com/AboutMe/MobileApplicationPrivacy
