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

Keyword &Parameter Description: index_name: This is an undeclared identifier which can be referenced only within the FORALL statement and only as the collection subscript


Question 1 . Compare SQL and PL/SQL Question 2 . Write a database trigger to implement the following check condition                          Given the following table

Negation (NOT, ¬) - SQL There are three rows instead of just two. As you can see, ¬ p is defined as in two-valued logic (2VL) when p is either true or false, but ¬ (unknown) i

%TYPE Attribute The %TYPE attribute gives the datatype of a record, field, nested table, database column, or the variable. You can use the %TYPE attribute as the datatype speci

Oracle 11 G new features associated with this release:- Enhanced ILM  - Information Lifecycle Management (ILM) has been around for the almost 10 years, but Oracle has made

#quesWrite a cursor to open an employee database and fetch the employee record whose age is greater than 45.tion..

Using raise_application_error The Package DBMS_STANDARD that is supplied with Oracle gives language facilities that help your application to interact with Oracle. For illustra

Keyword & Parameter Description: PRAGMA: These keywords signify that the statement is a pragma (i.e. compiler directive). The Pragmas are processed at the compile time, n