Question

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

Homework Answers

Answer #1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

1.Table Name :employees

create table employees(
employeeID Number primary key,
employeeName Varchar2(50),
salary Number,
datehired Date
);

Table structure in Oralce APEX :

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.

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
Oracle Assingment Introduction to databases Topics :Restricting and sorting data Create a query to display the...
Oracle Assingment Introduction to databases Topics :Restricting and sorting data Create a query to display the last name and salary of employees earning more than 1200 Display the last name and salary for all employees whose salary is not in the range of 5,000 and 10,000 Display the employee last name, job ID, and start date of employees hired between February 20, 1998, and May 1, 1998. Order the query in ascending order by start date. Display the last name...
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...
The following question is based on this table named Customer Column Name     Type              CustId          Integer P
The following question is based on this table named Customer Column Name     Type              CustId          Integer Primary Key, CustName        Varchar2(40), Balance         Number Gender          Varchar2(1) Write the Stored Function named GetCustDetails.       The function: Has one parameter named pCustName. Must return a text value Must search for a customer row that has a CustName value equal to pCustName If a match is found return the customer's name and balance in the following format: Customer Name: Fred   Gender M   Balance 20000 If a...
A. Create a PowerShell script named “restore.ps1” within the “Requirements2” folder. For the first line, create...
A. Create a PowerShell script named “restore.ps1” within the “Requirements2” folder. For the first line, create a comment and include your first and last name along with your student ID. Note: The remainder of this task shall be completed within the same script file, “restore.ps1.” B. Write a single script within the “restore.ps1” file that performs all of the following functions without user interaction: 1. Create an Active Directory organizational unit (OU) named “finance.” 2. Import the financePersonnel.csv file (found...
Using the Company database in Oracle, construct SQL queries for the following (note: I will make...
Using the Company database in Oracle, construct SQL queries for the following (note: I will make the files to create and populate the Company database available on Isadore shortly): List the last name and address of managers who have a dependent with the same first name as themselves. Retrieve the names of all employees who are directly supervised by ‘Franklin Wong’. Retrieve the names of employees in the Research department who work more than 20 hours per week on the...
BITS Corporation Exercises 14-16 14. Create a new table named Sept21 to contain the columns OrderNum,...
BITS Corporation Exercises 14-16 14. Create a new table named Sept21 to contain the columns OrderNum, TaskID, Description, ScheduleDate, QuotePrice for all rows on which the ScheduledDate is 9/21/2018 15. In the Sept 21 table, change the description of TaskID PI54 to “Misc. Printing” 16. In the Sept21 table, add a new order. The order number is 69123. The TaskID is OT99. The scheduled date is 9/21/2018. The quoted price is $99. The description is Other work.
1. What are three uses for a view? 2. Create a table named COPY_customers from the...
1. What are three uses for a view? 2. Create a table named COPY_customers from the customers table. 3. Use the CREATE or REPLACE option to create a view of all the columns in the COPY_customers table called view_ customers. 4. Use view_ customers to INSERT a row of data into the underlying COPY_customers table. Execute a SELECT * from COPY_customers to verify your DML command. 5. Show the contents of the view_ customers view. 6. Write the statement to...
Consider the following relational database:               STUDENT     (STDNO, SNAME, DEPTNO#)             &n
Consider the following relational database:               STUDENT     (STDNO, SNAME, DEPTNO#)               DEP                 (DEPTNO, DNAME)               COURSE        (CORSNO, CNAME, DEPTNO#, CMAX)               ENROLMENT       (STDNO#, CORSNO#, GRADE, EDATE) STUDENT.DEPTNO is the department number of the student. COURSE.DEPTNO is the department number that offers the course. ENROLMENT models the registrations of students in courses (M:M relationship) where the GRADE is the grade obtained by the student in the course. PART I : DATA DESCRIPTION LANGUAGE (DDL) Write DDL commands to create the four...
Save your select statements as a script. Place the semicolon at the end of each SQL...
Save your select statements as a script. Place the semicolon at the end of each SQL statement. Please number your select statements from 1 to 8 in your script and comment out each number. Include your name and student number as a comment at the top of your script. The name of the script has to be Assignment1_JohnSmith. Instead of JohnSmith use your First Name and Last Name. Upload your script trough Blackboard. Use SQL Developer to create the My...
Create an ERD diagram from the following problem: The Busy B Company wants to store data...
Create an ERD diagram from the following problem: The Busy B Company wants to store data about its employees’ skills. Each employee possesses one or more specific skills. In addition, several employees may have the same skill. The following facts need to be included in the database: 1. Employee name 2.Skill number 3.Skill name 4.Employee number 5. Date hired 6. Date of birth 7. Date skill acquired
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT