Search Term

Oracle Database
- - Install
- Company
- Licence
10053
Acfs
Active Instance Count
Actual Plan
Actual Statistics
Adaptive
Adaptive Plan
Addm
Analytic
Analytic Function
Archive Log
Archived Redo Log
Archivelog
Archivelog Change Mode
Archivelog Display Mode
Arraysize
Asm
Asm Installation
Authentication
Authid
Automatic Reoptimization
Autotask
Autotrace
Awr
Background Process
Between
Bi Strategy
Bitmap
Blevel
Block
Btree
Buffer
Buffer Cache
Buffer Pool
Bulk Load Index
Byte Or Character
Bytes Sent Via Sql Net To Client
Cache
Cardinality
Cartesian Join
Cascade
Cdb
Cdc
Change Pwd Sys System
Character Set
Chopt
Client
Cluster Scans
Clustering Factor
Cman.ora
Column
Commit
Compile
Compression
Concurrency
Connect As Sys Without Password
Connect Descriptor
Connect Identifier
Connect String
Connection Manager
Connection Parameter
Connection Pool
Consistency
Consistent Gets
Constraint
Context
Control File
Cpu Count
Ctas
Current Schema
Current User
Data Dictionary
Data File
Data Load
Data Pump
Data Redistribution
Database
Database Control
Database Link
Database Service
Datatype
Datatype Character
Datatype Conversion
Datatype Datetime
Datatype Numeric
Datawarehousing
Date
Db Block Gets
Db Block Size
Db Domain
Db File Multiblock Read Count
Db File Scattered Read
Db File Sequential Read
Db Name
Db Unique Name
Dba
Dbca
Dbms Application Info
Dbms Flashback
Dbms Lob
Dbms Lock
Dbms Monitor
Dbms Mview
Dbms Space
Dbms Xdb
Dbms Xplan
Dbwn
Ddl Lock
Deadlock
Dedicated Server
Dedicated Server Process
Dimension
Direct Path Insert
Direct Path Read
Directory
Directory Naming
Disk Asynch Io
Disk Group
Dispatcher
Display Cursor
Distributed Transaction
Dml Lock
Dop
Dual
Easy Connect Method
Edelivery
Em
Environment Variable
Exam 1z0 052
Exp
Expdp
Explain Plan
Explain Plan Against Autotrace
Extended Statistics
Extent
External Naming
External Table
External Table Clob
File
File System
Filter After Outer Join
First Rows
First Value
Fix Control
Flash Cache
Flashback
Flashback Query
Floating Point
Foreign Key
Free Space
Full Table Scans
Function Based Index
Gateway
Gateway Architecture
Gateway Data Dictionary
Gateway Data Dictionary Translation
Gateway Log
Gateway Registration
Global Name
Global Names
Glossary
Golden Gate
Grant
Granule
Grid
Group
Hardware
Hash Access
Hash Area
Hash Area Size
Hash Join
Height
High Water Mark
Hint Load
Hints
Histogram Analysis
How To Create A Time Dimension In Sql
If
Imp
Impdp
Index
Index Scans
Index Statistic
Initrans
Insert
Install 10g Rac
Install 11g
Install 11gr2 Oel Linux
Install 11gr2 Oel Linux X86 64
Install 12c
Installation
Installation10gr2 Windows
Instance
Instance Name
Integer
Interconnect
Internal Lock
Interval
Io
Java
Java Debug
Java Getversion
Java Procedure
Jdbc
Join Operation
Join Order
Language
Leaf Block
Lgwr
Library Cache
Like
Listener.ora
Listener
Lob
Local Naming
Lock
Lock Foreign Key
Logical Structure
Logminer
Long
Materialized View
Media Pack
Memory
Merge Join
Methodology For Defining The Analytic Workspace
Methodology For Designing And Building The Materialized Views
Minus
Mman
Monitor
Monitoring
Mos
Multiblock
Naming
Naming Method
Net
Net Manager
Net Service Alias
Net Service Name
Netca
Nls Date Format
Nls Date Language
Nls Lang
Nls Length Semantics
Nls Numeric Characters
Nls Parameter
Nls Sort
Noarchivelog
Nologging
Non Schema Object
Null
Number
Object
Oci
Odbc
Odbc Linux
Odbc Oracle Driver
Ofa
Optimizer Features Enable
Optimizer Goal
Ora 01720
Ora Error
Ora Hash
Ora Nls
Oracle Validated
Oracle Backup
Oracle Base
Oracle Character Set Function
Oracle Db Aq
Oracle Db Audit
Oracle Db Is Function
Oracle Green Computing
Oracle Home
Oracle Hostname
Oracle Hs Odbc Excel
Oracle Olap
Oracle Sid
Oracle Unqname
Oracle Varchar2 Char
Oracledb Emca How To Reconfigure
Oracledb Version
Oradb Example How To Detect Read From Temp
Oradb Table Logging Mode
Oraenv
Orainventory
Oug
Oui 10044
Oui
Package
Parallel
Parallel Degree Limit
Parallel Degree Policy
Parallel Dml
Parallel Enable
Parallel Execution Message Size
Parallel Max Servers
Parallel Min Percent
Parallel Min Servers
Parallel Monitoring
Parallel Partition
Parallel Rac
Parallel Server
Parallel Server Target
Parallel Servers Target
Parallel Threads Per Cpu
Parameter
Parameter File
Partition Exchange Loading
Path
Pattern Matching
Pctfree
Pdb
Performance
Performance Statistics
Pga
Pga Aggregate Target
Physical Io
Physical Reads
Physical Structure
Pivot
Plan Estimator
Plan Generator
Pmon
Pooled Server
Port
Pre Compute Operations
Predicate
Primary Key
Private Sql Area
Privilege
Producer Consumer
Profile
Ps
Query Coordinator
Query Optimizer Init Param
Query Rewriting
Query Tuning Example
Rac
Rank
Rda
Rdf
Read
Recovery
Recursive Calls
Recursive Calls Hard Parse
Recursive Calls Plsql Function Call
Recursive Calls Side Effects
Recursive Calls Space
Recycle Bin
Redo Index
Redo Log
Redo Log Bypass Generation
Redo Size
Regexp
Resource
Resource Manager
Ressource Manager
Result Set
Reverse Key Indexes
Role
Rollback
Row Lock
Rowid
Rowid Scans
Rownum
Runstats
Sample
Sample Schemas
Savepoint
Scheduler
Schema
Schema Object
Scn
Sdu
Security
Select Catalog Role
Select For Update
Selectivity
Sequence
Server Process
Server Result Cache
Service Handler
Service Name
Service Names
Service Registration
Session
Session Statistics
Sga
Shared Pool
Shared Server
Shared Sql Area
Sid
Skip Unusable Indexes
Software Owner
Sort Aggregate
Sort Area
Sort Area Size
Sort Join
Sorts Disk
Sorts Memory
Space
Special Character
Spfile
Sql
Sql Access Advisor
Sql Net Roundtrips To From Client
Sql Net Statistics
Sql Parallel Execution
Sql Plan Management
Sql Trace
Sql Tuning Advisor
Sqlloader Lob
Sqlnet.ora
Standby Database
Star Transformation
Startstop
Statspack
Storage
Stored Procedure
Stored Procedure Java
Stored Procedure Result Set
Synonym
Sysasm
Sysdate
Sysdba
Sysmetric
Sysoper
System Lock
System Tablespace
Table
Table Function
Table Lock
Table Size
Tablespace
Tempfile
Temporal Validity
Temporary Tablespace
Territory
Timed Statistics
Timestamp
Tkprof
Tns Admin
Tnsnames.ora
Tnsping
To Number
Trace
Trace File
Transaction
Transaction Table
Trigger
Ttc
Two Task
Undo
Usage
User
Userenv
Utl Mail
Utl Match
V Sql
V Sql Monitor
V Sql Plan
V Sql Plan Statistics
V Sql Plan Statistics All
V Sql Workarea
V Sqlarea
V Table
Version
View
Virtual Circuit
Virtual Column
Vpd
Wait
Why I Must Create Dimension In Oracle
Work Area
Workarea Size Policy
Xml
Xml Db

Home
Db
Oracle Database
Stored Procedure

Oracle Database - Stored Procedure

Table of Contents

About
Articles Related

About

stored procedure in Oracle

Articles Related

Oracle Database - PL/SQL - Result Sets from Stored Procedures

Discover More

Oracle Database - PL/SQL - Result Sets from Stored Procedures

ORACLE supports procedures (functions) which returns result sets. Thus, a stored procedure can act as a table or a view. Here is an example on the HR schema with a cursor variable:

Share this page:

Data (State)
Data (State)
DataBase
Data Processing
Data Quality
Data Structure
Data Type
Data Warehouse
Data Visualization
Data Partition
Data Persistence
Data Concurrency

Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Modeling
Process
Logical Data Modeling
Relational Modeling
Dimensional Modeling
Automata

Data Type
Number
Time
Text
Collection
Relation (Table)
Cube
Tree
Key/Value
Graph
Spatial
Color
Log

Measure Levels
Order
Nominal
Discrete
Distance
Ratio

Code
Compiler
Lexical Parser
Grammar
Function
Testing
Debugging
Shipping
Data Type
Versioning
Design Pattern

Infrastructure
Operating System
Monitoring
Cryptography
Security
File System
Network
Process (Thread)
Computer
Infra As Code

Marketing
Advertising
Analytics
Email

Web
Html
Dom
Http
Url
Css
Javascript
Selector
Browser
Web Services
OAuth

Contact
[email protected]
Privacy Policy
Status