CGIScripter
Features and Benefits
CGIScripter
Demo Available for download...
Bookmark
This Page
-- Script: example_create_table1.sql
-- Features: This sql script creates the Oracle
-- user, tablespace and table.
--
-- Notes: The DBA should update the start
-- and increment values of the sequence
-- before running this script.
--
-- The DBA should change the VARCHAR2(4000)
-- column sizes to appropriate values to
-- permit indexing of the columns. Oracle
-- permits indexes of up to 768 total column
-- sizes unless the Oracle Text
-- (formerly Context) feature is being used.
--
-- CLOB/BLOB datatype columns may be stored
-- within locally managed tablespaces
-- with Oracle 9.2.0. Otherwise, a dictionary
-- managed tablespace should be used.
--
-- This file only needs run if
-- the existing user, table and tablespaces
-- do not already exist in the destination
-- database.
--
-- Usage: sqlplus /nolog @example_create_table1.sql
--
-- Used By: run manually by Oracle DBA on the database server
-- Copyright 2003 by .com Solutions Inc.
--
-- ---------------------- Revision History ---------------
-- Date By Changes
-- 2-27-2003 dsimpson Initial Release
--
-- This output file was created by CGIScripter version 1.48 on Thu Aug
21 12:48:58 2003. By .com Solutions Inc. www.dotcomsolutionsinc.net
--
connect user1/user1pwd
-- create Oracle table to match structure of FileMaker file
CREATE TABLE user1.example
(
item VARCHAR2(4000) NULL,
category VARCHAR2(4000) NULL,
picture BLOB default EMPTY_BLOB() NULL,
model VARCHAR2(4000) NULL,
serial_number VARCHAR2(4000) NULL,
information CLOB default EMPTY_CLOB() NULL,
date_purchased DATE NULL,
depreciation NUMBER NULL,
assigned_display NUMBER NULL,
depreciation_life NUMBER NULL,
remaining_life NUMBER NULL,
cost NUMBER NULL,
book_value NUMBER NULL
)
TABLESPACE users
LOGGING
STORAGE (BUFFER_POOL DEFAULT)
NOPARALLEL
NOCACHE;
COMMENT ON TABLE user1.example IS
'Table created by CGIScripter';
quit
