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

Everyone has one nostril that is larger than the other.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Pregnant women usually experience a heightened sense of smell beginning late in the first trimester. Some experts call this the body's way of protecting a pregnant woman from foods that are unsafe for the fetus.

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

Did you know?

The U.S. Preventive Services Task Force recommends that all women age 65 years of age or older should be screened with bone densitometry.

The twin method can be used to investigate genetic and environmental influences on the development o The twin method can be used to investigate genetic and environmental influences on the development o
Procedures and Diagnostic Tests Related to the Female Reproductive System Procedures and Diagnostic Tests Related to the Female Reproductive System
Variable Gases: Ozone Variable Gases: Ozone
Method for creating Roundup-Ready soybeans Method for creating Roundup-Ready soybeans
Estimates of carbon stored in the plants and soils of different ecosystems. Estimates of carbon stored in the plants and soils of different ecosystems.
Plot of Land (Modified Offset Method) - Boxed Plot of Land (Modified Offset Method) - Boxed
Video: Transcription - Introns and exons

For a complete list of videos, visit our video library