Describe the use of PL/SQL tables

Ads

 
 

Share on Google+Share on Google+

hemant kumar
Describe the use of PL/SQL tables
1 Answer(s)      7 years ago
Posted in : SQL

Describe the use of PL/SQL tables

Ads
View Answers

November 18, 2010 at 5:35 PM


Hi,

PL/SQL tables are scalar arrays that can be referenced by a binary integer. They can be used to hold values for use in later queries or calculations. In Oracle they will be able to be of the %ROWTYPE designation, or RECORD.

Thanks,


Ads









Related Tutorials/Questions & Answers:
Describe the use of PL/SQL tables
Describe the use of PL/SQL tables  Describe the use of PL/SQL tables   Hi, PL/SQL tables are scalar arrays that can be referenced by a binary integer. They can be used to hold values for use in later queries
PL/SQL tables
PL/SQL tables   hii, Describe the use of PL/SQL tables ?   hello, PL/SQL tables are scalar arrays that can be referenced by a binary integer. They can be used to hold values for use in later queries or calculations
Advertisements
Toby's PL/SQL Editor
Toby's PL/SQL Editor What is the PL/SQL Editor? The PL/SQL editor is a plugin... easily develop and test PL/SQL code. Download You can download the plugin...) of the existing features. PL/SQL Syntax Colouring
PL/SQL Terms
PL/SQL Terms       SQL SQL is an English like language consisting of commands to store... and if using, use it in the same sequence and use Commit frequently to release locks
use tables to structure forms
use tables to structure forms  How can I use tables to structure forms
use tables to structure forms
use tables to structure forms  How can I use tables to structure forms
Getting the Records in PL/SQl between Date Ranges - JDBC
Getting the Records in PL/SQl between Date Ranges  Getting the records Between the Dates in PL/SQL Database by using JDBC and display through JSP
Executing anonymous pl/sql block and get resultset in Java
Executing anonymous pl/sql block and get resultset in Java  Hello All, I would like to execute the anonymous pl sql block and need to get the resultset object. I got the code which can be done by using cursors inside the pl sql
Mysql List Tables
Mysql List Tables       The Tutorial illustrate an example from 'Mysql  List Tables'. To understand this example we use show tables query that return the list
Nest tables within tables
Nest tables within tables  Can I nest tables within tables
Mysql Describe
Mysql Describe       Mysql Describe is used to describe the table Field,Type,Null etc attribute . Understand with Example The Tutorial elaborate an example from 'Mysql Describe
Oracle Tutorial
, FETCH and EXECUTE. PL/SQL An extension to SQL called Procedure Language/SQL. PL.... PL/SQL programs may contain if....then, while, and loop. PL/SQL reduces the traffic between the application and database. PL/SQL's native compilation is easy
tables to structure forms
tables to structure forms  How can I use tables to structure forms
tables to structure forms
tables to structure forms  How can I use tables to structure forms
tables for layout
tables for layout  Are there any problems with using tables for layout
tables for layout
tables for layout  Are there any problems with using tables for layout
Joining tables using criteria
Joining tables using criteria  How do i join more than three tables... column from child table,the joined tables must be maintain primary key relationship.please give examples and describe
Describe synchronization in respect to multithreading.
Describe synchronization in respect to multithreading.  Hi, Describe synchronization in respect to multithreading. thanks,   Are you eager the search related to Java programming query. Let us check
CSV tables
CSV tables  hello, What are CSV tables?   hii, CSV Tables cannot be indexed.CSV Tables are the special tables, data for which is saved into comma-separated values files
SQL All Tables
SQL All Tables       SQL All Tables is used to show all the tables in database. Understand with Example The Tutorial illustrate an example from 'SQL All Tables'. To understand
Comparing tables
Comparing tables  How to compare two or more tables in the Mysql database using jdbc
Mysql List Tables
Mysql List Tables       The Tutorial illustrate an example from 'Mysql  List Tables'. To understand this example we use show tables query that return the list
Mysql Table Describe
Mysql Table Describe       Mysql Table Describe is used to describe the Fieldtype, Datatype, Null... an example from 'Mysql Table Describe'. To understand the example we create a table 'Stu
Describe the effects of a server failure on the application
Describe the effects of a server failure on the application Prev  Chapter 7. Validate, tune and troubleshoot... Describe the effects of a server failure on the application
Natural Join / joining two tables
two tables according to common field and Create a new virtual field. We will use the following query- SELECT * FROM employee NATURAL JOIN emp_sal ... tables before join -- "employee" table "emp_sal" table
program to create nested tables
program to create nested tables  program to create nested tables
Join the two tables in sql
Join the two tables in sql  How to join the two tables in SQL ..and return the value from common column in SQL Database
Get the list of tables in Sybase
Get the list of tables in Sybase   hello, How to get the list of tables in Sybase?   hii, Select name from sysobjects where type="...." it will give You list according to where clause
Using criteria for multiple tables
Using criteria for multiple tables  How to join more than three tables,those tables must be maintain primary key relation ship using Hql criteria & projections
Using criteria for multiple tables
Using criteria for multiple tables  How to join more than three tables,those tables must be maintain primary key relation ship using Hql criteria & projections
Create Database and tables in MySQL
Create Database and tables in MySQL  Hi, How to create database and tables in MySQL Database? Explain me step-by-step as I am beginner in MySQL... input statement. mysql> Now to create database use following command

Ads

 
Advertisement null

Ads