i have this database qoustion i need help with it The query that displays birth date of employee whose ssn = 123456789 in format 'SaturdayJanuary/09/Nineteen Sixty-Five'O a. select to_char( bdate ,'day) || ('mon/dd/year' ) from employee where ssn = 123456789;O b. select to_char( bdate ,'Day Month/dd/Year' ) from employee where ssn = 123456789;c. None of the aboveO d. select to_char( bdate ,Year") from employee where ssn = 123456789; Select d.dependent_name from employee e join dependent d on (e.ssn=Dd.essn) wheree.lname='Wong' and d.relationship='Son'; this query shows:O a. The sons of employee Wong.O b. All employees sons.O c. The relationship between Wong and Son.O d. Make an error.

to_char() is used to format output in specified format Day Month/dd/Year is the format to get…

The query that displays birth date of employee whose ssn = 123456789 in format 'Saturday January/09/Nineteen Sixty-Five' a. select to_char( bdate ,'day') || ('mon/dd/year' ) from employee where ssn = 123456789; b. select to_char( bdate ,'Day Month/dd/Year' ) from employee where ssn = 123456789; O c. None of the above O d. select to_char( bdate ,'Year') from employee where ssn = 123456789;

The query that displays birth date of employee whose ssn = 123456789 in format 'Saturday January/09/Nineteen Sixty-Five' a. select to_char( bdate ,'day') || ('mon/dd/year' ) from employee where ssn = 123456789; b. select to_char( bdate ,'Day Month/dd/Year' ) from employee where ssn = 123456789; O c. None of the above O d. select to_char( bdate ,'Year') from employee where ssn = 123456789;

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter12: Subqueries And Merge Statements

Section: Chapter Questions

Problem 12MC

See similar textbooks

Similar questions

Repeat Exercise 6, but this time use the EXISTS operator in your query.
Employee_id Name Salary 1001 Annie 6000 1009 Ross 4500 1018 Zeith 7000 This is Employee table. Which of the following employee_id will be displayed for the given query? SELECT * FROM employee WHERE employee_id>1009; a) 1009, 1001, 1018 b) 1009, 1018 c) 1001 d) 1018
Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order. (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)
Create a query that that returns staff members’ names (excludingdoctors), their hourly rates, number of hours worked and Salary(calculated column; there are 13 employees in the clinic) for the twoweeks period Create a query that returns all patients enrolled permanently with one ofthe doctors Create a query that would create a list of all patients that were seen by aparticular doctor on a given date (i.e. 12 December, 2020)
Janice Jones bought three books in May 2018. It was assigned a sale id of 2 in the volume table. Use PARTITION BY to list the ISBNs of those books, the individual selling price, and the total (do this in one query). CREATE TABLE `volume` ( `inventory_id` int(11) NOT NULL,`ISBN` char(17) DEFAULT NULL,`condition_code` int(11) DEFAULT NULL,`date_acquired` date DEFAULT NULL,`asking_price` decimal(7,2) DEFAULT NULL,`selling_price` decimal(7,2) DEFAULT NULL,`sale_id` int(11) DEFAULT NULL);
The view V_PAT_ADT_LOCATION_HX returns one row of information per bed stay. The column ADT_DEPARTMENT_ID is the ID of the bed's department. The column ADT_DEPARTMENT_NAME is that department's name. Two distinct departments can potentially share the same name. Which of the following queries would return exactly one row per department and display the name of the department? A. SELECT ADT_DEPARTMENT_ID, MIN(ADT_DEPARTMENT_NAME) FROM V_PAT_ADT_LOCATION_HX GROUP BY ADT_DEPARTMENT_ID B. SELECT MIN(ADT_DEPARTMENT_ID), ADT_DEPARTMENT_NAME FROM V_PAT_ADT_LOCATION_HX GROUP BY ADT_DEPARTMENT_ID C. SELECT 'ADT_DEPARTMENT_ID', ADT_DEPARTMENT_NAME FROM V_PAT_ADT_LOCATION_HX GROUP BY ADT_DEPARTMENT_ID D. SELECT ADT_DEPARTMENT_ID, 'ADT_DEPARTMENT_NAME' FROM V_PAT_ADT_LOCATION_HX GROUP BY ADT_DEPARTMENT_ID
Q1. Please write a query statement from emp table to display employee's empno, ename, length of ename, number of 'S',and number of 'L'. SQL> SELECT empno AS "EmpNo", ename AS "Emp Name", ... AS "Name Length", .... AS "# Of S", .... AS "# Of L"FROM emp; [IMAGE below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing
this is the code i run in sql developer CREATE TABLE MARKETING_CAMPAIGN(MACampID int,MACampName varchar(30) not null,MACampDescr varchar(100) not null,DiscountType varchar(100) not null,MACampStartDate char(10) not null,MACampEndDate char(10) not null,PRIMARY KEY (MACampID))INSERT INTO MARKETING_CAMPAIGNVALUES (1111,'discount','This is discount', 'discount type1' ,'12-02-2021', '02-22-2022')SELECT * FROM dual; ---------- Error starting at line : 1 in command -CREATE TABLE MARKETING_CAMPAIGN(MACampID int,MACampName varchar(30) not null,MACampDescr varchar(100) not null,DiscountType varchar(100) not null,MACampStartDate char(10) not null,MACampEndDate char(10) not null,PRIMARY KEY (MACampID))INSERT INTO MARKETING_CAMPAIGNVALUES (1111, 'discount','This is discount', 'discount type1' ,'12-02-2021', '02-22-2022')SELECT * FROM dualError report -ORA-00922: missing or invalid option00922. 00000 - "missing or invalid option"*Cause: *Action: whats this error for ?
Write a query to generate a report indicating the total number of sick leave daysfor each employee. The report should display the employee name and surnameand the total number of sick leave days. Arrange the report so that the records are ordered in descending order based on the number of sick leave days.Sample Results:EMPLOYEE_NAME EMPLOYEE_SURNAME TOTAL SICK LEAVE DAYSDerek Moore 20Andrew Crouch 13Neo Petlele 3Dominique Woolridge 2Nico Baird 1Q.2.3 Write a query that will indicate which employee has been booked off for the most number of days by doctor ‘D0001’. Display the employee name and surname, doctor name, and the number of days.Sample Results:EMPLOYEE_NAME EMPLOYEE_SURNAME DOCTOR_NAME NUMBER_OF_DAYSAndrew Crouch Thabo Ntlali 4
Assume you have these table CREATE TABLE Student (studid Char(9) Primary Key,FirstName Varchar2(50) NOT NULL,LastName Varchar2(50) NOT NULL,Email Varchar2(50) NOT NULL UNIQUE,PhoneNumber Number(8) NOT NULL UNIQUE,DateOfBirth Date NOT NULL,GPA Number(1,2) NOT NULL); CREATE TABLE Club (clubID Number(3) Primary Key,ClubName Varchar2(20) NOT NULL,studid Char(9) NOT NULL UNIQUE, Foreign key(studid) references Student(studid)); CREATE TABLE MemberOf (ClubID Number(3) Primary Key, Studid char(9), JoiningDate date, Foreign Key(ClubID) references club(clubID), Foreign Key(Studid) references Student(studid)); CREATE TABLE Activities (Actid Number(3) Primary Key,Acdt DATE NOT NULL,Place Varchar2(50) NOT NULL,durationNbHour Number NOT NULL); CREATE TABLE Organize (actid Number(3) Primary Key, clubID Number(3), Fee Number(4,2), Foreign Key(actid) references Activities(Actid),Foreign Key(clubID) references MemberOf(ClubID)); Write in SQL queries to populate the above tables by inserting minimum 4…
I think my query needs temp variables instead of using NEW but I am not sure how. Here is my query: delimiter // DROP TRIGGER trg_pic_hours; create trigger trg_pic_hours after insert on CREW for each row begin IF NEW.CREW_JOB = 'Pilot' THEN update PILOT set PIL_PIC_HRS = PIL_PIC_HRS + ( select CHAR_HOURS_FLOWN from CHARTER where CHAR_TRP = NEW.CHAR_TRP) where EMP_NUM = NEW.EMP_NUM; END IF; END // If I run the query with the NEW.CHAR_TRP entry errors out if I remove NEW from it it will run ok. I have attached the schema
In The SQL Oracle Application Using the UNION operator, write a query that displays the employee_id, job_id, and salary of ALL present and past employees. If a salary is not found, then just display a 0 (zero) in its place.

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

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

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

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

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

SEE MORE TEXTBOOKS