Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, I want to make each table and then try to type that is a necessary source of their inside! How can I do it??
Hello,
I want to make each table and then try to type that is a necessary source of their inside! How can I do it?? I'm a beginner of this Database Systems, please help me^^
E. Oracle SQL Developer : Table DBS211_231ZBB47.COUNTRIES@gkim74 File Edit View Navigate Run Team Iools Window elp Rem Creation Script for Oracle courses by Rem rem made up of 2 parts NAME "demobld 10g sql" - Drops and then Creates SIX tablesfor DEMO schema Rem needed for SQL Notes material in Version 11 onward Rem This set is a SUBSET of tables and data in the Human Resources or HR schema Rem Rem Added reps from CMC to employees table in 2021 Rem Rem Added other SQL from CMC covering ORDERS, PRODU CTS, ORDERLINES, CUSTOMERS Rem Later added Rep numbers to customers Rem Rem This PART of script will drop all SEQUENCES and TABLES related to DEMO schema Rem If this is the first time running, these DROPS will cause errors as no such sequence exists Rem Rem This script new for 20221 for dbs211 and dbs311 SET FEEDBACK 1 SET NUMWIDTH 10 SET LINESIZE 200 -SET TRIMSPOOLON -SET TAB OFF SET PAGESIZE 200 SET ECHOOFF PAUSE There will be errors for first time loading as you do not have the tables we are dropping / NOTE: The first time through there will be errors for the beginning as no sequences or tables exist To be able to drop \%/ DROP SEQUENCE locations_seq; DROP SEQUENCE departments_seq; DROP SEQUENCE employees_seq; DROP TABLE countries CASCADE CONSTRAINTS; DROP TABLE locations CASCADE CONSTRAINTS; DROP TABLE departments CASCADE CONSTRAINTS; DROP TABLE employees CASCADE CONSTRAINTS; DROP TABLE job_grades; DROP TABLE job_history; / This should be the end of the errors */ Rem Rem This PART of the script creates SX tables, populates data, adds associated constraints Rem and indexes for the DEMO user. Rem REM REM Create the COUNTRIES table to hold country information for customers
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started