1. Create an Oracle table with a minimum of two varchar(2) fields (one should be a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Create an Oracle table with a minimum of two varchar(2) fields (one should be a persons name), a char field, a numeric field with decimal places, a numeric field for a whole number and a date field. 2. Show me a description of the table. 3. Populate the table with data you should put in a variety of data so that it can be effectively queried. Show me one of the insert statements you used. The name varchar(2) fields should contain a name in the format last name slash first name middle name or initial if any. For example: o Doe/John M o Jones/Mary • Adams-Costa/Susan Ann o Langley/M Richard 4. Change two fields on a record and show me the before and after. 5. Make a change that effects more than one record (but not all) 6. Delete a record and show me the before and after 7. Alter the structure of the table by adding a column/field and populating it. Show me the results 8. Alter the structure of the table by adding characters to a varchar2 field. Show me the results. 9. Do a search and find out how to alter the structure of the table by deleting a column. Demonstrate and show me the results. Site the address where you found the explanation. 10. Do a search and find out how to alter the structure of the table by renaming a column. Demonstrate and show me the results. Site the address where you found the explanation. 11. Do a query that does a sort on two fields. Tell me which field is the primary sort and which is the secondary sort. varchar2 field. Show me the results. 12. Do a query that uses between and show me the results 13. Do a query that uses the % and the underscore or characters that are missing. 14. Do a query that looks for one thing that has to be true and either of two other things. 15. Do a query that does a calculation for the results where you add two things together and divide by something. 16. Do a query where you test for null or something else. 17. Do a query that uses NOT and explain what you tried to accomplish. 18. Do a query where you convert to upper or lower case to test. 19. Do a query that uses the substr. 20. Do a query that uses the instr function. 21. Show me a list of tables (generated in Oracle) of the tables you have created. 22. Backup one of your tables. Show me the instruction you executed and show me the list of tables including the backup. 1. Create an Oracle table with a minimum of two varchar(2) fields (one should be a persons name), a char field, a numeric field with decimal places, a numeric field for a whole number and a date field. 2. Show me a description of the table. 3. Populate the table with data you should put in a variety of data so that it can be effectively queried. Show me one of the insert statements you used. The name varchar(2) fields should contain a name in the format last name slash first name middle name or initial if any. For example: o Doe/John M o Jones/Mary • Adams-Costa/Susan Ann o Langley/M Richard 4. Change two fields on a record and show me the before and after. 5. Make a change that effects more than one record (but not all) 6. Delete a record and show me the before and after 7. Alter the structure of the table by adding a column/field and populating it. Show me the results 8. Alter the structure of the table by adding characters to a varchar2 field. Show me the results. 9. Do a search and find out how to alter the structure of the table by deleting a column. Demonstrate and show me the results. Site the address where you found the explanation. 10. Do a search and find out how to alter the structure of the table by renaming a column. Demonstrate and show me the results. Site the address where you found the explanation. 11. Do a query that does a sort on two fields. Tell me which field is the primary sort and which is the secondary sort. varchar2 field. Show me the results. 12. Do a query that uses between and show me the results 13. Do a query that uses the % and the underscore or characters that are missing. 14. Do a query that looks for one thing that has to be true and either of two other things. 15. Do a query that does a calculation for the results where you add two things together and divide by something. 16. Do a query where you test for null or something else. 17. Do a query that uses NOT and explain what you tried to accomplish. 18. Do a query where you convert to upper or lower case to test. 19. Do a query that uses the substr. 20. Do a query that uses the instr function. 21. Show me a list of tables (generated in Oracle) of the tables you have created. 22. Backup one of your tables. Show me the instruction you executed and show me the list of tables including the backup.
Expert Answer:
Answer rating: 100% (QA)
1 Create an Oracle table with a minimum of two varchar2 fields one should be a persons name a char field a numeric field with decimal places a numeric field for a whole number and a date field CREATE ... View the full answer
Posted Date:
Students also viewed these programming questions
-
In your own words. With a minimum of five sentences, post your response to the topic: Our textbook defines morality as the ways that we think about, feel about, and treat people who are different...
-
A complete accounting cycle with a minimum of 60 ~ 90 transactions for a business startup. General Guide Lines: 1. The initial Capital is Rs. 3~ 5 million. 60% invested by owner. 40% through 5 years...
-
Modify Theorem 11.1 so that it can be used to appraise the maximum error when 2 is unknown. This method can be used only after the data have been obtained.
-
In 2014, Elbert Corporation had net cash provided by operating activities of $531,000; net cash used by investing activities of $963,000; and net cash provided by financing activities of $585,000. At...
-
Why is the service-profit chain important to operations management?
-
Jethro Company, a retailer, had the following account balances as of April 30, 2012: During May, the company completed the following transactions. May 3 Paid one-half of 4/30/12 accounts payable. 4...
-
Incubators are organizations that provide startups with shared operating space. They are sponsored by universities, city or county governments, or nonprofit organizations. Incubators also provide...
-
Park Co.s long-term available-for-sale portfolio at December 31, 2010, consists of the following. Park enters into the following long-term investment transactions during year 2011. Jan. 29 Sold 7,000...
-
A student addresses a bully mocking another student, " what you're doing isn't even clever or funny, everyone has a right ti express who they are.. you know like we say every morning.. liberty and...
-
Swiss watches are not expensive unless they are made of gold. (S, W, E, M ) Translate the following statements into symbolic form. Avoid negation signs preceding quantifiers. The predicate letters...
-
An asset and liability are recorded for ______. Multiple choice question. contracts that transfer ownership of the leased asset only all leases, regardless of length or ownership transfer all leases...
-
What are the various ways that a state- owned airline can be privatized?
-
Define ASM (or ASK), RASM (or RASK), CASM (or CASK), LF, and yield. How might a change in one affect another?
-
Your best taxable investment opportunity has an EAR of 6.4%. Your best tax-free investment opportunity has an EAR of 2.8%. If your tax rate is 32%, which opportunity provides the higher after-tax...
-
Consider a project that requires an initial investment of $102,000 and will produce a single cash flow of $153,000 in five years. a. What is the NPV of this project if the five-year interest rate is...
-
Distinguish between procedural justice and distributive justice in the context of equity theory.
-
Al Sevice Corporation 2022 operating performance vs. 2021 operating performance Calculate the following financial factors for both years: Place X in proper colum 2022 2021 Better Worse Al Sevice...
-
Describe a job you have had in the past or a job you are very familiar with. Indicate the negative aspects of the job and how it could be improved with current human resource management techniques.
-
Macquarie Manufacturing Ltd prepared the following planned production data for the forthcoming year ending 30 June 2019. Required (a) Prepare a table showing the predetermined factory overhead rate...
-
Beautiful Bottles Pty Ltd, bottle manufacturer for the food industry, has just installed a job order costing system. The company uses machine hours to apply its overhead to work in process. On 1 May...
-
Green Consultants Pty Ltd specialise in consulting on landscape design. The company developed a predetermined charge-out rate based on hours for each of its consultants on 1 July 2019 to assign the...
Study smarter with the SolutionInn App