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

About one in five American adults and teenagers have had a genital herpes infection—and most of them don't know it. People with genital herpes have at least twice the risk of becoming infected with HIV if exposed to it than those people who do not have genital herpes.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

You should not take more than 1,000 mg of vitamin E per day. Doses above this amount increase the risk of bleeding problems that can lead to a stroke.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Did you know?

Hip fractures are the most serious consequences of osteoporosis. The incidence of hip fractures increases with each decade among patients in their 60s to patients in their 90s for both women and men of all populations. Men and women older than 80 years of age show the highest incidence of hip fractures.

Researchers must inform potential participants of a study's procedures so that consent may be o Researchers must inform potential participants of a study's procedures so that consent may be o
Time Estimates for Specific Office Procedures Cont. Time Estimates for Specific Office Procedures Cont.
How to solve a pair of linear equations using the Addition-Subtraction Method How to solve a pair of linear equations using the Addition-Subtraction Method
Generation of diversity by variable V-J joining mechanisms Generation of diversity by variable V-J joining mechanisms
How to get the derivative of x/(2-sqrt(x)) using delta method How to get the derivative of x/(2-sqrt(x)) using delta method
Offset Method Plot of Land with Length Line Offset Method Plot of Land with Length Line
Video: Blood Flow through the Human Heart

For a complete list of videos, visit our video library