Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL 13551-Describe-the-use-of-PL Describe the use of PL/SQL tables
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


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


Describe the use of PL/SQL tables


Advertisement
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,



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
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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
types of relationships in tables
-to-many and many-to-many relationships while designing tables?   hi... tables with primary and foreign key relationships. One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign
Advertisements
 

 

 

DMCA.com