SQL Script
Listing C.51 is to be used to create the tables in PointBase. After creating the user, these commands can be run on the console. Alternatively, you can run this file in PointBase by running the command file listed in C.52.
Listing C.51. pointbase_setup.sql
CREATE TABLE "SYSTEM"."CREDIT_CARD_DETAILS" ( "PROFILE_ID" DECIMAL(10,0), "CARD_NUMBER" VARCHAR(20), "CARD_TYPE" VARCHAR(20), "EXPIRATION_MONTH" VARCHAR(20), "EXPIRATION_YEAR" VARCHAR(20) ); COMMIT; CREATE TABLE "SYSTEM"."FLIGHT" ( "AIRLINE_ID" DECIMAL(10,0), "AIRLINE_NAME" VARCHAR(20), "FROM_LOCATION" VARCHAR(20), "TO_LOCATION" VARCHAR(20), "DEPARTURE_TIME" TIME, "ARRIVAL_TIME" TIME, "DURATION" DECIMAL(5,2), "TOTAL_SEATS" DECIMAL(3,0), "FLIGHT_ID" DECIMAL(10,0) NOT NULL ); COMMIT; ... |
Get Sams Teach Yourself BEA WebLogic Server 7.0™ in 21 Days now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
