Does Oracle have an equivalent of SQL Server’s table variables?

by

Yes.

Declare TABLE TYPE variables in a
PL/SQL declare block. Table variables
are also known as index-by table or
array. The table variable contains one
column which must be a scalar or
record datatype plus a primary key of
type BINARY_INTEGER. Syntax:

DECLARE
TYPE type_name IS TABLE OF
(column_type |
variable%TYPE |
table.column%TYPE
[NOT NULL]
INDEX BY BINARY INTEGER;

— Then to declare a TABLE variable of this type:
variable_name type_name;

— Assigning values to a TABLE variable:
variable_name(n).field_name :=
‘some text’; — Where ‘n’ is the
index value

Ref: http://www.iselfschooling.com/syntax/OraclePLSQLSyntax.htm

You might want to also take a look at Global Temporary Tables

More Related Contents:

  1. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  2. How are dates stored in Oracle?
  3. How do I escape a reserved word in Oracle?
  4. How to put more than 1000 values into an Oracle IN clause [duplicate]
  5. ORA-30926: unable to get a stable set of rows in the source tables
  6. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  7. Fetch Oracle table type from stored procedure using JDBC
  8. “Safe” TO_NUMBER()
  9. When or Why to use a “SET DEFINE OFF” in Oracle Database
  10. error: ORA-65096: invalid common user or role name in oracle
  11. Oracle insert if not exists statement
  12. Error : ORA-01704: string literal too long
  13. Oracle client ORA-12541: TNS:no listener [closed]
  14. Sql*plus always returns exit code 0?
  15. Reason why oracle is case sensitive?
  16. Faster alternative in Oracle to SELECT COUNT(*) FROM sometable
  17. Oracle date difference to get number of years
  18. SQL Fiddle Output Error
  19. oracle PL/SQL how to calculate range ip for IPv6 cidr
  20. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  21. Oracle: how to add minutes to a timestamp?
  22. How can I describe a table in Oracle without using the DESCRIBE command?
  23. How to drop multiple interval partitions based on date?
  24. How to list active / open connections in Oracle?
  25. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  26. BEGIN – END block atomic transactions in PL/SQL
  27. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  28. How to Register Pluggable Database(PDB) with new created LISTENER
  29. Grant Select on all Tables Owned By Specific User
  30. ORA-12704: character set mismatch

Leave a Comment