| Calling Functions within a CREATE Statement [message #372810] |
Sat, 10 March 2001 19:10  |
jimmy
Messages: 21
Registered: November 2000
|
Junior Member |
|
|
Hello.
If you plan on responding to this post, I'd like to thank you in advance.
My problem is that I have a function that accepts a parameter (example: 'AMD') and returns an updated stock quote for the ticker entered.
Currently I have this table:
CREATE Table Stocks (
symbol VARCHAR2(3),
quote NUMBER);
My question is if its possible to use that function described earlier and embed it within the CREATE statement so that the values under the quote attribute are derived from the function and uses the value under the symbol attribute as a parameter.
Perhaps its not possible at all with SQL.
Thanx in advance for answering.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
