Help me solve the following questions

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

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.