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

Parkinson's disease is both chronic and progressive. This means that it persists over a long period of time and that its symptoms grow worse over time.

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Did you know?

There are 60,000 miles of blood vessels in every adult human.

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

A method to measure the lateral movement of membrane proteins. A method to measure the lateral movement of membrane proteins.
Procedures and Diagnostic Tests Related to the Integumentary System Procedures and Diagnostic Tests Related to the Integumentary System
Procedures and Diagnostic Tests Related to the Endocrine System Procedures and Diagnostic Tests Related to the Endocrine System
A typical variable cam timing control valve. The solenoid is controlled by the engine computer and ... A typical variable cam timing control valve. The solenoid is controlled by the engine computer and ...
Solve the solution set of the following system using Graphical Method. Solve the solution set of the following system using Graphical Method.
Generation of the F2 trihybrid phenotypic ratio using the forked-line method Generation of the F2 trihybrid phenotypic ratio using the forked-line method
Video: Cognitive development by Piaget (Preoperational stage or intelligence)

For a complete list of videos, visit our video library