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 100 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?

The U.S. Pharmacopeia Medication Errors Reporting Program states that approximately 50% of all medication errors involve insulin.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

Refraction Through Uniform and Variable Thickness Glasses Refraction Through Uniform and Variable Thickness Glasses
Procedures and Diagnostic Tests Related to the Eye Cont Procedures and Diagnostic Tests Related to the Eye Cont
X-Ray Procedures Requiring Special Preparations X-Ray Procedures Requiring Special Preparations
Balance the given redox reduction equation in basic solution using the half reaction method Balance the given redox reduction equation in basic solution using the half reaction method
A gene map for chromosome 12 from the NCBI database Map Viewer A gene map for chromosome 12 from the NCBI database Map Viewer
Hermann Muller and the Drosophila ClB Chromosome Method Hermann Muller and the Drosophila ClB Chromosome Method
Video: Coronary Heart Disease

For a complete list of videos, visit our video library