Table Creation: Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows: CREATE TABLE TABLE_NAME ( Column1 datatype, Column2 datatype, … );

Question

Want to see the full answer?

Answer 1

Question

Chapter 7, Problem 13P

a.

Program Plan Intro

Table Creation:

Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

Column1 datatype,

Column2 datatype,

…

);

b.

Program Plan Intro

Copying the values from another table:

It is possible to copy code from another table using the “INSERT INTO” statement. The syntax is given as follows:

INSERT INTO NEW_TABLE SELECT COLUMN_NAME FROM OLD_TABLE;

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

The Employee database contains a page displaying summary information, including EMPNO, ENAME, JOB, HIREDATE, SAL and DEPTNO columns from the EMP table. Create a PL/SQL block with scalar variables to retrieve this data and then display it on screen. An initialized variable should provide the EMPNO value. Test the block using the employee number 7369.

A. Write SQL statements to create a table named STUDENT, with the following columns: StdID: character field of width 10, null is not allowed AdvID: character field of width 10, null is not allowed B. Given that the STUDENT table is created in part (a), write a SQL statement to insert a constraint to STUDENT table created in part (a) to designate StdID as the primary key (Do not recreate another STUDENT since it was already done in part a).

Write a PL/SQL script to print all the details of the Jobs table using a cursor. Your query must include %RowType (to access the column names and datatypes of jobs table), and a cursor attribute to print the total number of rows returned. DEPARTMENTS LOCATIONS DEPARTMENT_ID * DEPARTMENT_NAME F P * LOCATION_ID STREET_ADDRESS POSTAL_C MANAGER_ID LOCATION_ID JOB_HISTORY PF* EMPLOYEE_ID * START_DATE CITY P END DATE F * JOB_ID F STATE_PROVINCE F COUNTRY_ID DEPARTMENT_ID EMPLOYEES EMPLOYEE_ID FIRST_NAME LAST_NAME U * EMAIL PHONE_NUMBER HIRE_DATE * JOB_ID P. COUNTRIES P COUNTRY_ID COUNTRY_NAME F JOBS REGION_ID P * JOB_ID * JOB_TITLE MIN_SALARY MAX_SALARY SALARY COMMISSION_PCT REGIONS IF MANAGER_ID P * REGION_ID REGION_NAME F DEPARTMENT_ID

Answer 2

Question

Chapter 7, Problem 13P

a.

Program Plan Intro

Table Creation:

Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

Column1 datatype,

Column2 datatype,

…

);

b.

Program Plan Intro

Copying the values from another table:

It is possible to copy code from another table using the “INSERT INTO” statement. The syntax is given as follows:

INSERT INTO NEW_TABLE SELECT COLUMN_NAME FROM OLD_TABLE;

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 7, Problem 13P

a.

Program Plan Intro

Table Creation:

Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

Column1 datatype,

Column2 datatype,

…

);

b.

Program Plan Intro

Copying the values from another table:

It is possible to copy code from another table using the “INSERT INTO” statement. The syntax is given as follows:

INSERT INTO NEW_TABLE SELECT COLUMN_NAME FROM OLD_TABLE;

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 7, Problem 13P

a.

Program Plan Intro

Table Creation:

Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

Column1 datatype,

Column2 datatype,

…

);

b.

Program Plan Intro

Copying the values from another table:

It is possible to copy code from another table using the “INSERT INTO” statement. The syntax is given as follows:

INSERT INTO NEW_TABLE SELECT COLUMN_NAME FROM OLD_TABLE;

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 7, Problem 13P

a.

Program Plan Intro

Table Creation:

Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

Column1 datatype,

Column2 datatype,

…

);

b.

Program Plan Intro

Copying the values from another table:

It is possible to copy code from another table using the “INSERT INTO” statement. The syntax is given as follows:

INSERT INTO NEW_TABLE SELECT COLUMN_NAME FROM OLD_TABLE;

Answer 6

Chapter 7, Problem 13P

a.

Program Plan Intro

Table Creation:

Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

Column1 datatype,

Column2 datatype,

…

);

Answer 7

Chapter 7, Problem 13P

a.

Program Plan Intro

Table Creation:

Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

Column1 datatype,

Column2 datatype,

…

);

Answer 8

b.

Program Plan Intro

Copying the values from another table:

It is possible to copy code from another table using the “INSERT INTO” statement. The syntax is given as follows:

INSERT INTO NEW_TABLE SELECT COLUMN_NAME FROM OLD_TABLE;

Answer 9

b.

Program Plan Intro

Copying the values from another table:

It is possible to copy code from another table using the “INSERT INTO” statement. The syntax is given as follows:

INSERT INTO NEW_TABLE SELECT COLUMN_NAME FROM OLD_TABLE;

Answer 10

Expert Solution & Answer

Answer 11

Expert Solution & Answer

Answer 12

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 13

Ch. 7 - Prob. 1RQ Ch. 7 - Explain why the following command would create an...Ch. 7 - Prob. 3RQ Ch. 7 - Explain why it might be more appropriate to...Ch. 7 - What is the difference between a column constraint...Ch. 7 - What are referential constraint actions?Ch. 7 - Rewrite the following WHERE clause without the use...Ch. 7 - Explain the difference between an ORDER BY clause...Ch. 7 - Explain why the following two commands produce...Ch. 7 - What is the difference between the COUNT aggregate...

Table Creation: Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows: CREATE TABLE TABLE_NAME ( Column1 datatype, Column2 datatype, … );

Solution Summary: The author explains the syntax for creating a table in Data Definition Language (DDL).

Concept explainers

Videos

Table Creation:

Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

Column1 datatype,

Column2 datatype,

…

);

Copying the values from another table:

It is possible to copy code from another table using the “INSERT INTO” statement. The syntax is given as follows:

INSERT INTO NEW_TABLE SELECT COLUMN_NAME FROM OLD_TABLE;

Want to see the full answer?

Chapter 7 Solutions

Table Creation: Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows: CREATE TABLE TABLE_NAME ( Column1 datatype, Column2 datatype, … );

Solution Summary: The author explains the syntax for creating a table in Data Definition Language (DDL).

Concept explainers

Videos

Table Creation: Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows: CREATE TABLE TABLE_NAME ( Column1 datatype, Column2 datatype, … );

Copying the values from another table: It is possible to copy code from another table using the “INSERT INTO” statement. The syntax is given as follows: INSERT INTO NEW_TABLE SELECT COLUMN_NAME FROM OLD_TABLE;

Want to see the full answer?

Chapter 7 Solutions

Table Creation:

Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

Column1 datatype,

Column2 datatype,

…

);

Copying the values from another table:

It is possible to copy code from another table using the “INSERT INTO” statement. The syntax is given as follows:

INSERT INTO NEW_TABLE SELECT COLUMN_NAME FROM OLD_TABLE;