24-07-2012, 11:28 AM
Using SQL Queries to Insert
Using SQL Queries to Insert.ppt (Size: 611.5 KB / Downloads: 40)
Lesson A Objectives
After completing this lesson, you should be able to:
Run a script to create database tables automatically
Insert data into database tables
Create database transactions and commit data to the database
Create search conditions in SQL queries
Update and delete database records and truncate tables
Using Scripts to Create Database Tables
Script
Text file that contains one or more SQL commands
Run a script
Type start at SQL prompt
Blank space
Full path and filename of script file
Format Models
Also called format mask
Used to specify different output format from default
For NUMBER data types
9 represents digit
For DATE/TIMESTAMP data types
Choose formats for year day, date, etc.
Inserting LOB Column Locators
Oracle stores LOB data in separate physical location from other types of data
LOB locator
Structure containing information that identifies LOB data type
Points to alternate memory location
Create blob locator
EMPTY_BLOB()