| PL/SQL ? [message #2062] |
Wed, 19 June 2002 12:55  |
Samuel Jenkins
Messages: 3
Registered: June 2002
|
Junior Member |
|
|
I have a table with 3 columns
account_number,
loc,
currency
Can I create a temporary table in pl/sql with the same info as above with an additional column X (calculated field)
If so an example pls.
|
|
|
|
| Re: PL/SQL ? [message #2068 is a reply to message #2062] |
Wed, 19 June 2002 15:56  |
Siva Ram
Messages: 22
Registered: November 2001
|
Junior Member |
|
|
Hi Samuel
YES, u can create a PL/SQL block to create a temporary table, but I suggest you to create a view for this requirement as in a view u can have a computed field and it's easy to create a view rather than creating a PL/SQL block for creating a temporary table.
if u need help, do send me an email.
Thank You
Siva Ram
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
