Working with Database Objects in Oracle PL/SQL

Q

Where to find answers to frequently asked questions on Working with Database Objects in Oracle PL/SQL?

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Working with Database Objects in Oracle PL/SQL. Clear answers are provided with tutorial exercises on running DML statements, assign table data to variables, using the implicit cursor, defining and using RECORDs with table rows.

Use DML Statements in PL/SQL in Oracle

Cannot Use DDL Statements in PL/SQL in Oracle

Use Variables in SQL Statements in Oracle

Variable Names Collide with Column Names in Oracle

Name Conflicts between Variables and Columns in Oracle

Assign Query Results to Variables in Oracle

Error: Exact Fetch Returns More Rows in Oracle

Invoke Built-in Functions in PL/SQL in Oracle

Retrieve the Count of Updated Rows in Oracle

Implicit Cursor in Oracle

Assign Data from a Deleted Row to Variables in Oracle

What Is a RECORD in PL/SQL in Oracle

Define a Specific RECORD Type in Oracle

Define a Variable for a Specific RECORD Type in Oracle

Assign Field Values into RECORD Variables in Oracle

Retrieve Field Values from RECORD Variables in Oracle

Define a Data Field as NOT NULL in Oracle

Define a RECORD Variable for a Table Row in Oracle

Assign a Table Row to RECORD Variable in Oracle

Insert a RECORD into a Table in Oracle

Update a Table Row with a RECORD in Oracle

Define a Variable to Match Column Data Type in Oracle

Sample scripts used in this FAQ collection assumes that you are connected to the server with the HR user account on the default database instance XE. See other FAQ collections on how to connect to the server. It is also assumed that you are using SQL*Plus to practice the tutorial exercises.

 

Use DML Statements in PL/SQL in Oracle

Scope of Local Variables in Oracle

⇑⇑ Oracle Database Tutorials

2018-10-13, 1603🔥, 0💬