A collection of 23 FAQs on working with database objects in 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.
- Can DML Statements Be Used in PL/SQL?
- Can DDL Statements Be Used in PL/SQL?
- Can Variables Be Used in SQL Statements?
- What Happens If Variable Names Collide with Table/Column Names?
- How To Resolve Name Conflicts between Variables and Columns?
- How To Assign Query Results to Variables?
- Can You Assign Multiple Query Result Rows To a Variable?
- How To Run SQL Functions in PL/SQL?
- How To Retrieve the Count of Updated Rows?
- What Is the Implicit Cursor?
- How To Assign Data of the Deleted Row to Variables?
- What Is a RECORD in PL/SQL?
- How To Define a Specific RECORD Type?
- How To Define a Variable of a Specific RECORD Type?
- How To Assign Values to Data Fields in RECORD Variables?
- How To Retrieve Values from Data Fields in RECORD Variables?
- How To Define a Data Field as NOT NULL?
- How To Define a RECORD Variable to Store a Table Row?
- How To Assign a Table Row to a RECORD Variable?
- How To Insert a Record into a Table?
- How To Update a Table Row with a Record?
- How To Define a Variable to Match a Table Column Data Type?
No comments:
Post a Comment