Question

Oracle: It keeps saying error in line 1, how do I fix it: --DROP TABLE DROP...

Oracle:

It keeps saying error in line 1, how do I fix it:

--DROP TABLE
DROP TABLE Inventory;
DROP TABLE Orders;
DROP TABLE Order_Line;
DROP TABLE Item;
DROP TABLE Order_Source;
DROP TABLE Category;
DROP TABLE Customer;

Homework Answers

Answer #1

In the given set of queries, The first line is a single line comment above your executable queries. A single-line comment can appear within a statement, at the end of a line. If there is an error message displaying, the lack of spaces could be the cause. We need to end the comment with a line break. Please remove extra spaces after first line(If there are any) and pressing the <ENTER> key to add a new line and remove the errors.

--DROP TABLE

DROP TABLE Inventory;

DROP TABLE Orders;

DROP TABLE Order_Line;

DROP TABLE Item;

DROP TABLE Order_Source;

DROP TABLE Category;

DROP TABLE Customer;

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
-- Drop the tables if they existDROP TABLE REP CASCADE CONSTRAINTS;DROP TABLE CUSTOMER CASCADE CONSTRAINTS;DROP TABLE...
-- Drop the tables if they existDROP TABLE REP CASCADE CONSTRAINTS;DROP TABLE CUSTOMER CASCADE CONSTRAINTS;DROP TABLE ORDERS CASCADE CONSTRAINTS;DROP TABLE ITEM CASCADE CONSTRAINTS;DROP TABLE ORDER_LINE CASCADE CONSTRAINTS;-- You are to change CUSTOMER to CUSTOMERS for the Colonial database to avoid conflict with the CUSTOMER table in Tal.-- Create the tablesCREATE TABLE REP(REP_NUM CHAR(2) PRIMARY KEY,LAST_NAME CHAR(15),FIRST_NAME CHAR(15),STREET CHAR(15),CITY CHAR(15),STATE CHAR(2),POSTAL_CODE CHAR(5),COMMISSION DECIMAL(7,2),RATE DECIMAL(3,2) );CREATE TABLE CUSTOMER(CUSTOMER_NUM CHAR(3) PRIMARY KEY,CUSTOMER_NAME CHAR(35) NOT NULL,STREET CHAR(20),CITY CHAR(15),STATE CHAR(2),POSTAL_CODE CHAR(5),BALANCE DECIMAL(8,2),CREDIT_LIMIT DECIMAL(8,2),REP_NUM CHAR(2) );CREATE...
How do I fix my error of binding on line 74? #include <iostream> #include <fstream> #include...
How do I fix my error of binding on line 74? #include <iostream> #include <fstream> #include <cctype> #include <cstring> #include <iomanip> using namespace std; #include "AvlTree.h" class WordCount { public:     char *word;     int *lines;     int count;     int size;     bool operator<(const WordCount &rhs) const {return strcmp(word, rhs.word) < 0;}     bool operator!= (const WordCount &rhs) const {return strcmp(word, rhs.word) != 0;}     WordCount():lines(NULL), count(0), size(0) {word = new char[1]; word[0] = '\0';}     friend ostream& operator<<...
Do 1: In Oracle Apex, create a table named “employees” give the table the following columns:...
Do 1: In Oracle Apex, create a table named “employees” give the table the following columns: Column name data type employeeID Number employeeName Varchar2(50) salary Number datehired Date Create the database script that builds the above table
Why there is an issue with this linkert-scale and how I can fix it? In the...
Why there is an issue with this linkert-scale and how I can fix it? In the last month, on how many days did you carry a weapon to school? Response choices: 0 days, 1 day, 2 or 3 days, 4 or 5 days This is the item and question. Based on Linker-scale guidelines what is the issue with the item? No extra info available.
How do I fix my code to collect ONLY hashtag instead of accumulating all the information...
How do I fix my code to collect ONLY hashtag instead of accumulating all the information about the number of occurrences of all words from the textfile? Please help to fix below codes. tweetcount=0 maxcount=0 count = 0 with open('elon-musk.txt') as book: for tweet in book: count += 1 print("Number of tweets:", count) print() with open('elon-musk.txt') as book: for line in book: s count = len(line.split()) if count>maxcount: maxline = line maxcount = count tweetcount += 1 print("Tweet with max...
How do I solve a question saying, if the the ten worst students with an average...
How do I solve a question saying, if the the ten worst students with an average mark of 38% withdrew from a class of 80 students with a mean of 65% what would be the class average of the remaining 70 students?
how do i calculate the Absolute Error(error/actual sales)?
how do i calculate the Absolute Error(error/actual sales)?
i need answer for Following Questions: 1: Use the Drag and Drop function to put the...
i need answer for Following Questions: 1: Use the Drag and Drop function to put the following events in the order they occur in the Amazon product receiving and order fulfillment process: Put the item in a bin/tote. Once the item is in its bin in its specific location, it is on sale on the website A customer purchases the item from Amazon.com Receive product from the vendor on 53 foot trailers, on pallets or in case quantity. Create a...
Can explain how to do these problems? 1 Type II Error: For the roulette table in...
Can explain how to do these problems? 1 Type II Error: For the roulette table in (Q6), determine which hypothesis testing scenario has the larger Type II error probability for a two-sided hypothesis for HO: p=18/19: 1. a) N=10,000, p=0.96 , α=0.05 OR b) N=10,000, p=0.97 , α=0.05. 2. a) N=10,000, p=0.96, α=0.05 OR b) N=50,000, p=0.96, α=0.05. 3. a) N=10,000, p=0.97, α=0.05 OR b) N=10,000, p=0.97, α=0.01. Describe how the Type II error is influenced by N, p and...
1. interpret column graphs of mean and standard error of the mean. 2. how do I...
1. interpret column graphs of mean and standard error of the mean. 2. how do I predict (interpolate/extrapolate) using a linear equation? Give me an example.
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT