How do you place the results of a SELECT command into variables in PL/SQL?
How do you place the results of a SELECT command into variables in PL/SQL?
Chapter5: Data Manipulation And Transaction Control
Section: Chapter Questions
Problem 6RQ
Related questions
Question
How do you place the results of a SELECT command into variables in PL/SQL?
Expert Solution
Step 1
In PL/SQL, The SELECT INTO statement places data by retrieving from the result set into the specified variable.
In case, the SELECT statement is returning multiple rows at a time, then the TOO_MANY_ROWS exception is raised. If no row is returned, NO_DATA_FOUND exception is raised.
Syntax:
SELECT column_1, column_2,.......,Column_n INTO variable_1, variable_2,......, variable_n FROM table_name WHERE <expression>;
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning