SQL and PL-SQL Tutorial 1.0

SQL and PL-SQL Tutorial 1.0

Sushant Sharma  ❘ Freeware
Android
共 235 票
最新版本
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 免費軟體。
UpdateStar Premium Edition UpdateStar Premium Edition
使用UpdateStar Premium Edition,保持軟體更新從未如此簡單!
Google Chrome Google Chrome
Google Chrome:快速、安全、免費的瀏覽器,並與 Google 整合良好
Microsoft Edge Microsoft Edge
Microsoft Edge:一款搭載 Copilot 的瀏覽器,具備強大的安全性與省電能力
Microsoft OneDrive Microsoft OneDrive
使用 Microsoft OneDrive 簡化檔管理
Microsoft Visual C++ 2015 Redistributable Package Microsoft Visual C++ 2015 Redistributable Package
使用 Microsoft Visual C++ 2015 Redistributable Package 提高系統性能!
Microsoft Visual C++ 2010 Redistributable Microsoft Visual C++ 2010 Redistributable
運行可視 C++ 應用程式的基本元件

最新更新


SQL Server Management Studio 22.12.1

Overview of SQL Server Management Studio (SSMS) SQL Server Management Studio (SSMS) is a graphical, integrated environment for managing Microsoft data platform products including SQL Server, Azure SQL Database, Azure SQL Managed …

Microsoft 365 Apps for Business 16.0.20625.20108

Microsoft 365 Apps for Business: ReviewMicrosoft 365 Apps for Business is a subscription-based, cloud-connected offering that provides the latest installable Office desktop applications together with 1 TB of OneDrive for Business storage…

Cryptomator 2.5.1

Cryptomator editor’s review: open-source client-side encryption for cloud storage Cryptomator is a mature, open-source client-side encryption tool that encrypts files and filenames locally before they are uploaded to cloud services.