Help me solve the following questions
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →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
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds