Select into statement - syntax, PL-SQL Programming

SELECT INTO Statement 

The SELECT INTO statement retrieve data from one or more database tables, and then assigns the selected values to the variables or fields.

Syntax:

2094_Select into statement.png

1006_Select into statement1.png

Posted Date: 10/8/2012 7:40:49 AM | Location : United States







Related Discussions:- Select into statement - syntax, Assignment Help, Ask Question on Select into statement - syntax, Get Answer, Expert's Help, Select into statement - syntax Discussions

Write discussion on Select into statement - syntax
Your posts are moderated
Related Questions
Iteration Schemes The bounds of a loop range can be variables, literals, variables, or expressions but must compute to integers. Below are some of the examples. As you can see t

Autonomous versus Nested Transactions Though an autonomous transaction is started by the other transaction, it is not a nested transaction for the reasons shown below: (i)

Parameter and Keyword Description: EXIT: An unconditional EXIT statement (i.e., one without a WHEN clause) exits the present loop instantly. The Execution resumes with th

%FOUND Until the SQL data manipulation statement is executed, the %FOUND yields NULL. Afterward, the %FOUND yields TRUE, when an INSERT, UPDATE, or DELETE statement affected o

Avoid the NOT NULL Constraint In the PL/SQL, using the NOT NULL constraint incur a performance cost. Consider the illustration as shown below: PROCEDURE calc_m IS m NUMB

i NEED TO CREATE 3 guiS IN pl/sql sERVER PAGE FORM

Raise_application_error -  procedure of package DBMS_STANDARD , allows to issue an user_defined error messages by stored sub-program or database trigger.

Great Plains (Microsoft Dynamics) Purchases Report Project Description: I want to build a purchases report that matches the General Ledger. presently, when I join the PM20

Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server

SSRS Report Writing Project Description: This report is part of a larger project to make a SQL Server Reporting Service (SSRS) based reporting solution. There can be more rep