Regular Expressions and User Access in Oracle Database 10g
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Overview/Description
To demonstrate how to use regular expression support and control user access in Oracle 10g
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with RDBMS technologies and programming techniques
Expected Duration (hours)
1.9
Lesson ObjectivesRegular Expressions and User Access in Oracle Database 10g
identify how to use regular expression support in SQL.
use regular expression functions to search, match, and replace strings.
use regular expression support to search for and manipulate strings.
create users, grant system privileges, assign roles, and change passwords.
grant, pass on, confirm, and revoke object privileges.
write SQL statements to control user access to an Oracle database.
Course Number:223293_eng