Imate žicu za učenje?

Manipulating Large Objects in PL/SQL

Overview/Description
To use LOBs and the DBMS_LOB package

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration (hours)
1.9

Lesson Objectives

Manipulating Large Objects in PL/SQL

  • associate internal and external LOBs with their corresponding data types and interfaces and distinguish between the features of external and internal LOB components.
  • create a DIRECTORY object and initialize and populate a BFILE data type.
  • reference and update a BFILE data type.
  • associate DBMS_LOB mutators and observers with their corresponding functions and procedures and outline the rules associated with using DBMS_LOB routines.
  • initialize, insert, and update LOB columns and content using SQL and the DBMS_LOB package.
  • create and test a temporary LOB and remove LOB values.
  • initialize, update, and remove LOBs.
  • Trajanje: 
    2 h
    Šifra: 
    216725_ENG

    Koraci do učenja

    1Prijavi se

    Prijavite se, a ako nemate korisničko ime, registrirajte se.

    2Pronađi i upiši program

    Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.

    3Uči

    Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.

    »Detaljne upute

    Trebate pomoć?