最新版本
1.0
1.0
可安全安裝
This comprehensive tutorial on Oracle SQL and PL/SQL provides a detailed exploration of definitions, syntax, and practical examples that are beneficial for both novices and experienced users alike.
Below is a list of the SQL topics included in the tutorial:
- Create Table
- Alter Table
- Rename and Drop Table
- Insert into Table
- Update and Delete Statements
- Transaction Control Statements
- SELECT Statement
- Components of SQL Statements
- Truncate Table
- BETWEEN Operator
- DISTINCT/UNIQUE
- Character Manipulation: CONCAT
- WHERE Clause
- INSTR Function
- DUAL (Dummy Table)
- SQL Functions
- Conversion Functions
- DECODE Function
- Implicit & Explicit Conversion
- Using CASE in SQL
- NVL, NVL2 & COALESCE
- Date Functions
- GROUP BY Clause
- GROUP BY Clause with Filter
- HAVING Clause
- Group Functions
- SQL Joins
- Inner Vs Outer Join
- COMMIT-ROLLBACK Data State
- Locking in SQL
- MERGE Statement
- Types of Tables
- RR & DD Date Format
- Pseudo-columns
- SQL Constraints
- Views & Inline Views
- WITH CHECK OPTION in Views
- Indexes
- Create User and Grants
- Synonyms
The following topics are covered in PL/SQL:
- PL/SQL Block
- Types of Variables
- SQL Functions in PL/SQL
- Conditional/Selection Control
- Loops in PL/SQL
- Cursors in PL/SQL
- Cursors with Parameters </ li >
- PL/SQL Reference Cursors </ li >
- Bulk Collect and Bulk Bind </ li >
- PL/SQL Records Data Type </ li >
- Composite Data Type - VARRAY </ li >
- Composite Data Type - NESTED TABLES </ li >
- Composite Data Type - INDEX BY TABLE </ li >
- Implicit Exceptions </ li >
- Explicit Exceptions </ li >
- Exception Trapping Functions </ li >
- PL/SQL PROCEDURE </ li >
- PL/SQL FUNCTION </ li >
- PL/SQL PACKAGE </ li >
- Trigger </ li > </ ul >
概述
SQL and PL-SQL Tutorial 是由 Sushant Sharma 開發的 Freeware 軟體,屬於 Education 類別。
SQL and PL-SQL Tutorial 的最新版本為 1.0,發佈日期為 2024/12/27。 此軟體最初於 2024/12/27 新增至我們的資料庫。
SQL and PL-SQL Tutorial 可在下列作業系統上執行:Android。
SQL and PL-SQL Tutorial 的使用者給予的評分為 4 顆星(滿分 5 顆星)。
最新評論
AMD Software
使用 AMD 軟體徹底改變您的圖形體驗LibreOffice
LibreOffice:一個免費和開源的辦公套件Rakuten Viber Messenger
與 Viber 訊息應用程式保持聯繫AIMP
用AIMP增強您的音樂體驗!Microsoft Edge
Microsoft Edge:一款搭載 Copilot 的瀏覽器,具備強大的安全性與省電能力3uTools
3uTools:終極 iOS 管理工具|
|
UpdateStar Premium Edition
使用UpdateStar Premium Edition,保持軟體更新從未如此簡單! |
|
|
Google Chrome
Google Chrome:快速、安全、免費的瀏覽器,並與 Google 整合良好 |
|
|
Microsoft Edge
Microsoft Edge:一款搭載 Copilot 的瀏覽器,具備強大的安全性與省電能力 |
|
|
Microsoft OneDrive
使用 Microsoft OneDrive 簡化檔管理 |
|
|
Microsoft Visual C++ 2015 Redistributable Package
使用 Microsoft Visual C++ 2015 Redistributable Package 提高系統性能! |
|
|
Microsoft Visual C++ 2010 Redistributable
運行可視 C++ 應用程式的基本元件 |