A Guide to SQL
9th Edition
ISBN: 9781111527273
Author: Philip J. Pratt
Publisher: Course Technology Ptr
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 3, Problem 5RQ
Explanation of Solution
a)
COMMISSIONRATE:
It is a valid option in Oracle...
Explanation of Solution
b)
POSTAL_CODE_5CHAR:
It is a valid option in Oracle...
Explanation of Solution
c)
SHIP TO ADDRESS:
It is an invalid option in Oracle...
Explanation of Solution
d)
INVOICE-NUMBER:
It is an invalid option in Oracle...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Say that you are interested in storing the numeric value 3,456,349.2334. What will be stored, with each of the following Oracle data types:a. NUMBER(11)b. NUMBER(11,1)c. NUMBER(11,-2)d. NUMBER(11,6)e. NUMBER
Which of the statements below is correct?
a.
Non-Oracle RDBMS use tablespaces as storage independent of database
b.
In Oracle, all users are given access to Tablespace.
c.
In Oracle, all instances use the same listener
d.
In Oracle, users who access the Database can all achieve the same results.
Im trying to run the following SQL in Oracle:
SELECT GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeCharged,SUM(FeeCharged) AS TotalFeeChargedFROM FEE_KRJOIN SERVICE_KR ON FEE_KR.ServiceID = SERVICE_KR.ServiceIDJOIN GUEST_KR ON SERVICE_KR.ServiceID = GUEST_KR.GuestIDWHERE ServiceName IN ('First Name', 'Last Name', 'Date Charged', 'Fee Description')WHERE ServiceName NOT IN (SELECT FEETYPE FROM REPORT_FILTER_KR)GROUP BY GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeChargedORDER BY SUM(FeeCharged) DESC;
And I'm recieving this error:
Error starting at line : 1 in command -SELECT GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeCharged,SUM(FeeCharged) AS TotalFeeChargedFROM FEE_KRJOIN SERVICE_KR ON FEE_KR.ServiceID = SERVICE_KR.ServiceIDJOIN GUEST_KR ON SERVICE_KR.ServiceID = GUEST_KR.GuestIDWHERE ServiceName IN ('First Name', 'Last Name', 'Date Charged', 'Fee…
Chapter 3 Solutions
A Guide to SQL
Ch. 3 - Prob. 1RQCh. 3 - How do you delete a table using SQL?Ch. 3 - Prob. 3RQCh. 3 - Prob. 4RQCh. 3 - Prob. 5RQCh. 3 - Prob. 6RQCh. 3 - Prob. 7RQCh. 3 - Prob. 8RQCh. 3 - Prob. 9RQCh. 3 - Prob. 10RQ
Ch. 3 - Prob. 11RQCh. 3 - Prob. 12RQCh. 3 - Prob. 13RQCh. 3 - Use SQL to complete the following exercises....Ch. 3 - Prob. 2TDCh. 3 - Prob. 3TDCh. 3 - Prob. 4TDCh. 3 - Prob. 5TDCh. 3 - Prob. 6TDCh. 3 - Prob. 7TDCh. 3 - Prob. 1CATCh. 3 - Add the following row to the ADVENTURE_TRIP table:...Ch. 3 - Prob. 3CATCh. 3 - Prob. 4CATCh. 3 - Prob. 5CATCh. 3 - Prob. 6CATCh. 3 - Review the data for the TRIP table in Figure 1-5...Ch. 3 - Colonial Adventure Tours would like to increase...Ch. 3 - Prob. 1SCGCh. 3 - Add the following record to the VACATION_UNIT...Ch. 3 - Delete the VACATION_UNIT table.Ch. 3 - Prob. 4SCGCh. 3 - Prob. 5SCGCh. 3 - Prob. 6SCGCh. 3 - The SERVICE_REQUEST table uses the CHAR data type...
Knowledge Booster
Similar questions
- Assume that all the statements from Q.6.2 have been executed on the database.Q.6.3.1 Write a SQL statement to get the list of all the team members in thedatabase. Include only the name and email address of the teammembers.arrow_forwardUse the given database to output the results of the following SQL queries: a.) SELECT DISTINCT C.buildingFROM Classroom AS CWHERE C.room number IN(SELECT S.room numberFROM Section AS SWHERE S.time slot id = A);arrow_forward64. ________ dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re-create the database. a. Archival b. Fuzzy c. SQL d. All of the mentionedarrow_forward
- please use live oracle : because when ever i run it it says: Unsupported Command ORA-06550: line 6, column 11: PLS-00103: Encountered the symbol "&" when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification> <a number> <a single-quoted SQL string> pipe <an alternatively-quoted string literal with character set specif this is the code: -- Taking user input for temperature ACCEPT temp NUMBER PROMPT 'Enter temperature: ' -- Declaring temp variable to be used for comparision DECLARE temp number; -- Initializing value BEGIN temp := &temp; -- If temperature is greater than 85 IF ( temp >85 ) THEN dbms_output.put_line('Hot!' ); -- If temperature is less than 85 and greater than 55 ELSIF (…arrow_forwardOracle sql Complete the following code to give me a cursor of ten federal holidays. You pass in the calendar year, it passes back a cursor of the year's holidays. 10 Federal Holidays. All can be logically calculated. Some are always on Monday... one is always on Thursday... the others.. Like Christmas... If Christmas is a Saturday, it's observed on Friday, if it's Sunday, it's observed on Monday. Here's the holidays: New Year's Day Martin Luther King President's Day Memorial Day Independence Day Labor Day Columbus Day Veteran's Day Thanksgiving Day Christmas Day Here's the starter code (I gave you the first two) create or replace PACKAGE BODY pkg_hldy AS PROCEDURE holiday_cursor (hldy_year_in NUMBER,cur_out OUT SYS_REFCURSOR)AS BEGIN OPEN cur_out FOR SELECTholiday_name,TRIM(TO_CHAR(holiday_calendar_date,'DAY') ) holiday_day,CASE adjWHEN 0 THEN holiday_calendar_dateELSECASE TRIM(TO_CHAR(holiday_calendar_date,'DAY') )WHEN 'SATURDAY' THEN holiday_calendar_date - 1WHEN 'SUNDAY' THEN…arrow_forwardIf an integer is multiplied by a NULL value, the result is: (refer to the tables in the JustLee Books database.)a. an integerb. a whole numberc. a NULL valued. None of the above—a syntax error message is returned.arrow_forward
- Which of the following SQL statements is invalid and returns an error message? ( refer to the tables in the JustLee Books database). a. ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); b. ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid); c. ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid); d. ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid); e. All of the above statements are invalidarrow_forwarduse oracle sql command line with found or notfound method --- with table Customer(customerNo,costomerName ,gender) Employee (employeeNo,employeeName,job) ,branch(No,Name), category(catNo,catogeryName) ___ 4) Create database package pointOfSal which contain the following A. procedure to add new customer which use validation method checkExistingCustomer using cursor to validate customer name if its not exists before, then add this new customer and generate the customer number automatically using database trigger. B. Method to add new Employee which use validation method checkExistingEmployee using cursor to validate Employee name if its not exists before, then add this Employee and generate the Employee number automatically using database trigger. C. procedure to add new Category which use validation method checkExistingCategory using exception to validate category name if its not exists before, then add this category and generate the category number automatically using database…arrow_forwardReferential integrity can affect which of the following row activities? Group of answer choices inserting, deleting, and changing a row changing a row inserting a new row deleting a rowarrow_forward
- Which of the following isn't a common error when entering and executing SQL statements? a) Misspelling a keyword b) Misspelling the name of a table c) Forgetting to attach the required database d) Forgetting to select the required databasearrow_forwardI am trying to create this index in oracle, the table and the column exists and is not found anywhere else in the database, but it's still telling me 'Province' is an invalid identifier. I've tried changing the column name (and create statement with it), but its all just not working. CREATE INDEX StudentProvince ON ADDRESS_KR (Province);arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning