Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
the Oracle command

the Oracle command

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

I answered questions 1-4.
I need help with questions 5-8!

**Oracle Assignment on Creating and Maintaining a Table (and Also a Few Queries)** **For all problems, show the Oracle command you wrote and the results produced.** 1. **Create an Oracle table** with a minimum of two varchar(2) fields (one should be a person's name), a char field, a numeric field with decimal places, a numeric field for a whole number, and a date field. 2. **Show a description** of the table. 3. **Populate the table** with data; include a variety of data for effective querying. Display an insert statement you used. The name varchar(2) fields should contain names in the format: last name, slash, first name, middle name or initial. Examples: - Doe/John M - Jones/Mary - Adams-Costa/Susan Ann - Langley/M Richard 4. **Change two fields** on a record and show both before and after the change. 5. **Make a change** that affects more than one record (but not all). 6. **Delete a record** and show both before and after the deletion. 7. **Alter the table structure** by adding a column/field and populating it. Show the results. 8. **Alter the table structure** by changing a varchar field to varchar2. Show the results. 9. **Search and find** how to alter the structure to delete a column. Demonstrate and show results. Provide the source of your explanation. 10. **Search and find** how to alter the structure to rename a column. Demonstrate and show results. Provide the source of your explanation. 11. **Query** that sorts data on two fields, specifying primary and secondary sorts. Show the results. 12. **Query** that uses 'between' to show results. 13. **Query** that uses a wildcard for missing characters. 14. **Query** that searches for one thing that has to be one of two others. 15. **Query** that adds a calculation to columns by adding two fields together and dividing by something. 16. **Query** where you test for nulls or something else. 17. **Query** that uses NOT and explains what you tried to accomplish. 18. **Query** converting upper or lower case to test. 19. **Query** that uses `substr`. 20. **Query** using the `instring` function. 21. **List** a
Transcribed Image Text:**Oracle Assignment on Creating and Maintaining a Table (and Also a Few Queries)** **For all problems, show the Oracle command you wrote and the results produced.** 1. **Create an Oracle table** with a minimum of two varchar(2) fields (one should be a person's name), a char field, a numeric field with decimal places, a numeric field for a whole number, and a date field. 2. **Show a description** of the table. 3. **Populate the table** with data; include a variety of data for effective querying. Display an insert statement you used. The name varchar(2) fields should contain names in the format: last name, slash, first name, middle name or initial. Examples: - Doe/John M - Jones/Mary - Adams-Costa/Susan Ann - Langley/M Richard 4. **Change two fields** on a record and show both before and after the change. 5. **Make a change** that affects more than one record (but not all). 6. **Delete a record** and show both before and after the deletion. 7. **Alter the table structure** by adding a column/field and populating it. Show the results. 8. **Alter the table structure** by changing a varchar field to varchar2. Show the results. 9. **Search and find** how to alter the structure to delete a column. Demonstrate and show results. Provide the source of your explanation. 10. **Search and find** how to alter the structure to rename a column. Demonstrate and show results. Provide the source of your explanation. 11. **Query** that sorts data on two fields, specifying primary and secondary sorts. Show the results. 12. **Query** that uses 'between' to show results. 13. **Query** that uses a wildcard for missing characters. 14. **Query** that searches for one thing that has to be one of two others. 15. **Query** that adds a calculation to columns by adding two fields together and dividing by something. 16. **Query** where you test for nulls or something else. 17. **Query** that uses NOT and explains what you tried to accomplish. 18. **Query** converting upper or lower case to test. 19. **Query** that uses `substr`. 20. **Query** using the `instring` function. 21. **List** a
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS