Oracle Database 12c R2 SQL: Creating Other Schema Objects

Oracle SQL 12c
  • 12 Videos | 55m 6s
  • Includes Assessment
  • Earns a Badge
Likes 15 Likes 15
Explore the basics of creating and using sequences and views in Oracle Database 12c SQL.

WHAT YOU WILL LEARN

  • describe views
    differentiate between simple and complex views
    create a view
    modify a view
    view information using USER_VIEWS
    define columns as visible or invisible
  • describe sequences
    demonstrate the use of the NEXTVAL and CURRVAL pseudocolumns
    use a sequence
    use the ALTER SEQUENCE statement
    view sequence information using USER_SEQUENCES
    create views and sequences

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group Functions   
Likes 18 Likes 18  
COURSE Oracle Database 12c R2 SQL: Using the Set Operators  
Likes 28 Likes 28  
CHANNEL Oracle Database 12c Administrator Certified Associate
Likes 82 Likes 82  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions
Likes 30 Likes 30  
COURSE Oracle Database 12c R2 SQL: Using the Set Operators  
Likes 28 Likes 28  
COURSE Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
Likes 34 Likes 34