This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: With Oracle Database, stored procedures cannot use a cursor variable, so another method must be used ... (Read 44 times)

tatyanajohnson

  • Hero Member
  • *****
  • Posts: 569
on: Jul 7, 2018
With Oracle Database, stored procedures cannot use a cursor variable, so another method must be used to access a table on a row by row basis.
 
  Indicate whether the statement is true or false

Question 2

Discuss what is meant by a data type of Numeric (10,3 ). Include at least one example.
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

flannelavenger

  • Sr. Member
  • ****
  • Posts: 322
Reply #1 on: Jul 7, 2018
Answer to Question 1

FALSE

Answer to Question 2

Numeric indicates a non-integer, decimal number in SQL Server. Oracle Database uses Number, and MySQL uses Decimal or Fixed. The (10,3 ) is in (n,d) format, where n is the total number of digits allowed, and d is the number of digits to the right of the decimal place. Thus, 10, 3 allows a maximum of ten digits, and the last three are considered to be to the right of the decimal place. For example, 1234567 would be read as 1234.567.


tatyanajohnson

  • Hero Member
  • *****
  • Posts: 569
Reply #2 on: Jul 7, 2018
Thank you :)


flannelavenger

  • Sr. Member
  • ****
  • Posts: 322
Reply #3 on: Jul 7, 2018
Happy to help you


« previous next »
 

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

The training of an anesthesiologist typically requires four years of college, 4 years of medical school, 1 year of internship, and 3 years of residency.

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

The Scientific Method The Scientific Method
Procedures and Diagnostic Tests Related to the Cardiovascular System Procedures and Diagnostic Tests Related to the Cardiovascular System
Procedures for Diagnostic Tests Related to the Digestive System Procedures for Diagnostic Tests Related to the Digestive System
Procedures and Diagnostic Tests Related to the Female Reproductive System Procedures and Diagnostic Tests Related to the Female Reproductive System
How do solve the derivative of y=x^3-x^2+x-2 using delta method. How do solve the derivative of y=x^3-x^2+x-2 using delta method.
Hermann Muller and the Drosophila ClB Chromosome Method Hermann Muller and the Drosophila ClB Chromosome Method
Video: Introduction to Photolithography - WC, BLF, PA, Hard and Soft baking

For a complete list of videos, visit our video library