Question: Table: F_STAFFS Column Data Type Length Precision Scale Nullable ID NUMBER No FIRST_NAME VARCHAR2 25 - No LAST_NAME VARCHAR2 35 = No BIRTHDATE DATE 7

Table: F_STAFFS Column Data Type Length Precision Scale Nullable ID NUMBER

No FIRST_NAME VARCHAR2 25 - No LAST_NAME VARCHAR2 35 = No BIRTHDATE

Table: F_STAFFS Column Data Type Length Precision Scale Nullable ID NUMBER No FIRST_NAME VARCHAR2 25 - No LAST_NAME VARCHAR2 35 = No BIRTHDATE DATE 7 - No SALARY NUMBER co 2 No OVERTIME RATE NUMBER 5 2 TRAINING VARCHAR2 Yes - - STAFF TYPE VARCHAR2 N N N 8 N N No MANAGER_ID NUMBER 5 0 Yes MANAGER_BUDGET NUMBER 2 Yes MANAGER_TARGET NUMBER 8 Yes 4. Write a query to display the birth date in the format of "One January Nineteen Twenty with alias name "New Date and overtime rate with alias name "Extra money". Arrange the data on the birth date from oldest date to latest date. Use the table F STAFFS. [3 Marks] ITDB202 - Structured Query Language Page 1 of 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I'm having trouble trying to figure out the correct commands to use for each of these questions. I keep getting errors. I'm using Oracle Apex to put in the SQL commands. Please help and I appreciate...

Using the following tables: 1.List the full name of members who are not from the state of IN nor IL. 2.List the full name of each member and the full names of the employees who ever assisted that...

Table: D EVENTS Column Data Type Length Precision Scale Nullable ID NUMBER 22 5 0 No NAME VARCHAR2 50 No EVENT_DATE DATE 7 No DESCRIPTION VARCHAR2 50 Yes COST NUMBER 22 8 2 No VENUE_ID NUMBER 22 5 0...

In SQL Create a view called faculty_view that shows the pid,fname as First Name, lname as Last Name, dept as Department and email_addr as Email Address from the PERSON, FACULTY and EMAIL tables....

Using the following tables: 6.List the member ID and the total number of transactions made by the members whose name (including first name and/or last name) contains letter R. 7.List the member ID,...

Using the following tables: 1.List the full name of members who are not from the state of IN nor IL. 2.List the full name of each member and the full names of the employees who ever assisted that...

1. Log on to your Oracle ApEx account. If you dont have a CUSTOMERS table, create one. Table: DEMO_CUSTOMERS Column Data Type Length Precision Scale Nullable CUSTOMER_ID NUMBER 22 - - No...

Using the following tables: 1.List the full name of members who are not from the state of IN nor IL. 2.List the full name of each member and the full names of the employees who ever assisted that...

Using the following tables write a sql command: List the full name and the total number of transactions handled by the full time employee. Rank your results in descending order on the total number of...

sql: List the full name and the total number of transactions handled by the full time employee. Rank your results in descending order on the total number of transactions. Table: MEMBERS Column Data...

You are to take one of the five identified categories of tools and identify two specific products from different vendors. Based on two products, please research the differences and similarities...

A corporation issued $1,000,000 of common stock in exchange for $1,000,000 of fixed assets. Where would this transaction be reported on the statement of cash flows?

What is the purpose of the Arithmetic Logic Unit ( ALU ) in von Neumann architecture? Manages memory access Stores program instructions Performs mathematical and logical operations Controls data...