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
How do i convert a Short date to a long date in Oracle SQL? for example.......
How do i convert a Short date to a long date in Oracle SQL? for example.... Convert 09/12/2015 to show as 12th September, 2015
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...
A Guide to SQL Questions 1. How do you create a table using SQL? 2. How...
A Guide to SQL Questions 1. How do you create a table using SQL? 2. How do you delete a table using SQL? 3. What are the common data types used to define columns using SQL? 4. Identify the best data type to use to store the following data in Oracle, in SQL Server, and in Access:    a. The month, day, and year that an employee was hired    b. An employee’s Social Security number    c. The department...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT