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:

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

Ask an Expert

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

Write your message here..

Related Questions

Map and order methods, Map and Order Methods: The values of the scalar... Map and Order Methods: The values of the scalar datatype like CHAR or REAL have a predefined order that allows them to be compared. While, the instances of an object type has

Natural join - sql, Natural Join - SQL In the absence of NATURAL JOIN... Natural Join - SQL In the absence of NATURAL JOIN Example has to be replaced by something rather more longwinded, as shown in Example. Example: Joining IS_CALLED and IS_EN

Existential quantification - sql, Existential Quantification - SQL Ex... Existential Quantification - SQL Existential quantification-stating that something is true of at least one object under consideration-can be expressed by OR(r,c), meaning tha

Fetching across commits, Fetching Across Commits The FOR UPDATE clause... Fetching Across Commits The FOR UPDATE clauses acquire exclusive all row locks. All rows are locked when you open the cursor, and when you commit your transaction they are unl

PROCEDURE, Create a procedure named DDPROJ_SP that retrieves project inform... Create a procedure named DDPROJ_SP that retrieves project information for a specific project based on a project ID. The procedure should have two parameters: one to accept a projec

Package dbms output in pl/sql, DBMS_OUTPUT: The Package DBMS_OUTPUT en... DBMS_OUTPUT: The Package DBMS_OUTPUT enables you to display output from the PL/SQL subprograms and blocks, that makes it easier to test and debug them. The procedure put_ line

Prepare a slq project, Project Description: I want to write some SQL st... Project Description: I want to write some SQL statements. The things I need are between pages 5-7. The only problem is that i want it till tomorrow. Skills required is SQL

Updating objects in pl sql, Updating Objects: To change the attributes... Updating Objects: To change the attributes of objects in an object table, you can use the UPDATE statement, as the illustration below shows: BEGIN UPDATE persons p SET p

Difference between implicit and explicit cursor, Implicit Cursor is declare... Implicit Cursor is declared and used by the oracle environment internally. while the explicit cursor is declared and used by the external user. more over implicitly cursors are no

Negation - sql, Negation (NOT, ¬) - SQL There are three rows instead o... 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