Practice 1 (continued)7. Show the structure of the EMP table. Create a query to display the name,job. hire date, and employee number for each employee, with employeenumber appearing first. Save your SQL statement to a file named plq7.sql.NameNull?ТуреEMPNONOT NULLNUMBER(4)ENAMEVARCHAR2(10)JOBVARCHAR2(9)MGRNUMBER(4)HIREDATEDATESALNUMBER(7,2)СOMMNUMBER(7,2)DEPTNΟNUMBER(2)8.Run your query in the file plq7.sql.EMPNOENAMEJOBHIREDATE7369 SMITHCLERK17/12/19807499 ALLENSALESMAN20/02/19817521 WARDSALESMAN22/02/19817566 JONESΜΑΝAGER02/04/19817654 MARTINSALESMAN28/09/19817698 BLAKEMANAGER01/05/19817782 CLARKMANAGER09/06/19817788 SCOTTANALYST09/12/19827839 KINGPRESIDENT17/11/19817844 TURNERSALESMAN08/09/19817876 ADAMSCLERK12/01/19837900 JAMESCLERK03/12/19817902 FORDANALYST03/12/19817934 MILLERCLERK23/01/198214 rows selected.

SELECT command is used to display the details specified column names

Show the structure of the EMP table. Create a query to display the name, job. hire date, and employee number for each employee, with employee number appearing first. Save your SQL statement to a file named plq7.sql.

Show the structure of the EMP table. Create a query to display the name, job. hire date, and employee number for each employee, with employee number appearing first. Save your SQL statement to a file named plq7.sql.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Create the following SQL Server queries that access the Northwind database. Place them in txt file…

A: This question comes from MySQL which is a topic in computer science. In this question we are going…

Q: CUSTOMER aus CODE CUS LNAME CUS FNAME CuS INITIAL CUS AREACODE CuS PHONE CUS BALANCE PRODUCT P cODE…

A: SQL (Structured Query Language) is a database query language. According to ANSI, it is the…

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: My SQL: The Car Maintenance team wants to add new maintenance tasks into the system. The team has…

A: This query selects all cars from the CARS table with a model year of 2021 and a manufacturer of…

Q: Write a query to display the first name, last name, and email address of employees hired from May 1,…

A: Here we have to write 2 queries whose details are as follows:Write a query to display the first…

Q: Select clause and from clause: Display the columns specified above in the problem statement from…

A: Write a query to display the author ID, first name, last name, and year of birth for all authors…

Q: List every table that contains a column named OWNER_NUM. The output table should display one column…

A: The first ever freely programmable computer came into play in 1936, however after that International…

Q: Using the retail.inventory table, pull the current stock percentage out of the future stock level…

A: The following solution is

Q: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

A: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

Q: Create a procedure, ADD_EMPLOYEE., to insert a new employee into the EMPLOYEES table. The procedure…

A: Call ADD_EMPLOYEE for the name Jane Harris in department 15. leaving other parameters with their…

Q: Create a SQL query that selects OrderID and OrderDate from the Orders database and OrderDetailID…

A: Definition A JOIN clause is used to join data from more than "2" tables together based on a common…

Q: ULL, Title VARCHAR2(30), TitleOfCourtesy VARCHAR2(25), BirthDate DATE, HireDate DATE, Address…

A: Dear Student, The required query with explanation is given below -

Q: please assist with the following questions. need to write a syntax in SQL server. Create an UPDATE…

A: It is defined as SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to…

Q: Create a new table, EMP_PROMOTION to store the employees information. You must use a subquery to…

A: Objective: A table "EMP_PROMOTION" would be created using sub-query from an existing relation…

Q: . Please write SQL codes to query data from member tables based on below criteria Please write a…

A: A number is odd number if its remainder when divided by 2 is not equal to 0

Q: The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all…

A: Answer

Q: Replace 456 with your last 3 digits in your student number The procedure must have: an input…

A: Code is given below. drop table VECHICLERENT; CREATE TABLE VECHICLERENT ( VEHICLE_ID…

Q: 2. Write a SQL statement to insert a new user with userId ‘XXXXX’ into the users table and populate…

A: The question has been solved in step2:

Q: CREATE TABLE Employee( firstName char(30) , lastName char(30) , hireDate date ,empNo int ,…

A: The table "Employee" with fields "firstName, "lastName", "date", "empNo", empInitial, and "years" is…

Concept explainers

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.

Question

Practice 1 (continued)
7. Show the structure of the EMP table. Create a query to display the name,
job. hire date, and employee number for each employee, with employee
number appearing first. Save your SQL statement to a file named plq7.sql.
Name
Null?
Туре
EMPNO
NOT NULL
NUMBER(4)
ENAME
VARCHAR2(10)
JOB
VARCHAR2(9)
MGR
NUMBER(4)
HIREDATE
DATE
SAL
NUMBER(7,2)
СOMM
NUMBER(7,2)
DEPTNΟ
NUMBER(2)
8.
Run your query in the file plq7.sql.
EMPNO
ENAME
JOB
HIREDATE
7369 SMITH
CLERK
17/12/1980
7499 ALLEN
SALESMAN
20/02/1981
7521 WARD
SALESMAN
22/02/1981
7566 JONES
ΜΑΝAGER
02/04/1981
7654 MARTIN
SALESMAN
28/09/1981
7698 BLAKE
MANAGER
01/05/1981
7782 CLARK
MANAGER
09/06/1981
7788 SCOTT
ANALYST
09/12/1982
7839 KING
PRESIDENT
17/11/1981
7844 TURNER
SALESMAN
08/09/1981
7876 ADAMS
CLERK
12/01/1983
7900 JAMES
CLERK
03/12/1981
7902 FORD
ANALYST
03/12/1981
7934 MILLER
CLERK
23/01/1982
14 rows selected.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Introduction

VIEW

plq7.sql

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Please help: Using the following sql file, how would you find List all the rows in which the prescription dates occur on or after November 14. How many doctors provide prescriptions with 30 tablets in total? List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order Find all patients rows whose first names include ‘George’ (Assume case sensitivity). List number of patients that do not have a phone number. Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End; //* Assignment_1 */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR…
Write queries in SQL to answer each of the following questions: 1. Find all students in Comp. Sci. dept 2. Find all students with total credits > 100 3. Find all students who took course in Spring 2010 (Remove duplicates please) 4. Find all courses taken by the student whose ID is 76543 and also find his name create table student (ID varchar(5), name varchar(20) not null, dept_name varchar(20), tot_cred numeric(3,0), primary key (ID) ); create table takes (ID varchar(5), course_id varchar(8), sec_id varchar(8), semester varchar(6), year numeric(4,0), grade varchar(2), primary key (ID, course_id, sec_id, semester, year) ); insert into student values ('00128', 'Zhang', 'Comp. Sci.', '102'); insert into student values ('12345', 'Shankar', 'Comp. Sci.', '32'); insert into student values ('19991', 'Brandt', 'History', '80'); insert into student values ('23121', 'Chavez', 'Finance', '110'); insert into student values ('44553', 'Peltier', 'Physics', '56'); insert into student values…
Write SQL CODE List all the Course Code (CRS_CODE) that are taught by a Professor that does not hold "Ph.D." as the highest degree (based on PROF_HIGH_DEGREE in the PROFESSOR table).
SQL: For every invoice, display the invoice number, invoice date and the total dollar amount for all products purchased in the invoice, ordered by invoice number in descending order and then by invoice date in ascending order. Here you will use an aggregate SUM(x,y) function in your SELECT clause to calculate the total dollar amount (a calculated field – name it TOTAL). Don’t forget to join on the tables as well. [hint: you should have 8 rows of output ordered properly]. select inv_number, inv_date sum(list_price) as 'total' from invoice, line order by desc inv_num, asc inv_date. I am getting the error: ORA-00923: FROM keyword not found where expected Am I formulating the query incorrectly?
Employee table: (E_Id,E_name,dept_name,Salary) Write Update query Increase salary by 5000 if salary between 30000 to 35000 Increase salary by 7000 if salary between 35001 to 41000 Increase salary by 9000 if salary between 41001 to 46000
List the item ID, description, and category for each pair of items that are in the same category. (For example, one such pair would be item FS42 and item PF19, because the category for both items is FSH.) Order the output by category. From MT SQL 10th Edition
Create a query to show the Technician Number, Last Name, First Name, Client Number,and Client Name for clients whose technician number is 23 (use Boolean variables).Save your query
Insert into table customerPayment, columns customerOrderld and total result set returned from query a. Select columns id and total from table customerOrder where column orderStateld is equal to subquery i. (select column id from table orderState where column state is equal to "Payment received") Write Test Case 1 as a SQL join query to do the following a. Select using concatenation of columns firstName and lastName from table www customer as Customer b. Select customerOrderId from table customerPayment as "Customer Order" c. Select description from table product as Product d. Select total from table customerOrder as “Product Total" e. Join tables customerPavment, customerOrder, customer, product f. Order by column lastName from table customer Alter table purchaseOrder add column total as data type decimal size 7,2, not null, default value of 0.0
sql question Write an UPDATE statement that modifies the Customers table. Change the password column to “reset” for every customer in the table.