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

Have Programming Question? Ask it here!
 
 
 


hemant kumar
Describe the use of PL/SQL tables
1 Answer(s)      3 years and 8 months 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
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
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
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
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
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
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
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
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
look up tables in java
look up tables in java  cachetables , how to apply cache mecanisam in java , i have some tables which is frequently used so i want to fetch first time and want to keep in some scope untill the application end . with out hitting
PHP Join Tables
PHP Join Tables  i wanted to show the information from two or more table in PHP. How can i do it with the PHP Join Tables
Different tables present in MySQL
Different tables present in MySQL  What are the different tables present in MySQL? Which type of table is generated when we are creating a table...; Hi friends, Total 5 types of tables we can create 1. MyISAM 2. Heap 3
tables in oracle 10g
tables in oracle 10g  sir i have created a table in oracle 10g,i want to know where this table is stored and how can i move this table to another pc and insert values
Elite Zebra Tables
Elite Zebra Tables       Elite Zebra Tables will turn your static html tables and boring web pages... original code. You can even have mutliple zebra tables on one page, all
pdf tables
pdf tables       In this program we are going to tell you how we can make a table in a pdf... will help us to make and use pdf file in our program. Now create a file named tablePDF
Criteria with Multiple Tables - Hibernate
Criteria with Multiple Tables  I am using Hibernates Criteria. How to get Joins using Criteria? e.g. instead of below query i want to use criteria then How i can? select user from TeamsUserEntity
Creating Database Tables and Indexes
Creating Database Tables and Indexes   ... or byte with a value of 255. Use of identifier quote character is permitted... length is in bytes not in characters. But if you use multi-byte characters
mysql select from multiple tables
mysql select from multiple tables   how can i select the date field from multiple tables in mysql?   "UNION" can be used to select data from multiple tables in my sql... for example (SELECT * from name where `name
merge tables in sql using union
merge tables in sql using union  How to create a new table in database by merging two tables using union function in SQL?   REATE TABLE new_table SELECT * FROM table1 UNION SELECT * FROM table2;   
Use of "parent" in XPath expression
how to use child axis in XPath expression . Now this section will describe the use of "parent" axis. "parent" axis consists of parent... Use of "parent" in XPath expression   
add same tables in jsp page
add same tables in jsp page  hi I have a table in my jsp page with data, now I want to add same copy of table without its default value in same page whenever I click add more table, how do I do
Data fetch from multiple SQL tables - Hibernate
access code into Hibernate code. The tables in SQL are not related using foreign... that would use table classes to retrieve data from 8 or 9 tables. Any...Data fetch from multiple SQL tables   I am in the process of writing
Map Java Objects with Database tables
Map Java Objects with Database tables  How to map Java Objects with Database tables?   First write Java domain objects ie. beans with setter and getter methods. Then map java class to table and database columns to Java
Join tables in the specific database
_name and Emp_sal. We are making use of the emp_name to join the tables... Join tables in the specific database   ... and tables in a database. Now to retrieve a particular row from a table
Hibernate Query setParameter()
This section describe use of query.setParameter() in HQL with example
Purge Data from Mysql tables
Purge Data from Mysql tables  Hi, i have to write a mysql procedure to purge data from tables. but written procedure clear entire tables data. Please give me the solution for purging data. CREATE DEFINER=`root`@`localhost
creating tables as an xml document - XML
creating tables as an xml document  Create a table of a medal tally of the Olympic Games as an XML document. The table must have the name of the country, No. of Gold medals, No. of Silver medals, and bronze medals and its total
Mysql Join 3 Tables
Mysql Join 3 Tables       Mysql Join 3 Tables is used to join 3 Tables using left join. The left join returns you only selective records which are common in tables
 

 

 

DMCA.com