Help me solve the following questions
April 21, 2024
SQL ASSIGNMENT Write the queries that show the following output in oracle database. Write an SQL statement to displays all tables in the database. TNAME TABTYPE CLUSTERID ββββββββββ ββ- βββDEPARTMENT TABLE DEPARTMENT60 TABLE DEPT TABLE EMPLOYEE32 TABLE EMPLOYEE33 TABLE EMPLOYEES TABLE EMPLOYEES30 TABLE EMPLOYEES31 TABLE EMPLOYEES34 TABLE EMPLOYEES35 TABLE EMPLOYEES36 TABLE 2. Write a query to show the details on the employees table as shown below. Name Null? Type ββββββββββββββ βββ βββββββββEMPLOYEE_ID NOT NULL NUMBER(7) FIRST_NAME VARCHAR2(20) LAST_NAME VARCHAR2(20) CELLPHONE VARCHAR2(12) EMAIL HIRE_DATE JOB_ID VARCHAR2(20) DATE VARCHAR2(5) SALARY NUMBER(12,2) MANAGER_ID NUMBER(6) DEPARTMENT_ID NUMBER(4) 3. Create a table named Job_grade with the following columns first_name last_name emplyee_id and populate it with data 4. Edit the table employees and add constraint on employees_id
Trust your assignments to an essay writing service with the fastest delivery time and fully original content.