Garayed.com
>
Oracle
How to use user function in SELECT query
User Name
Remember Me?
Password
FAQ
Members List
Calendar
Search
Today's Posts
Mark Forums Read
LinkBack
Thread Tools
Search this Thread
Display Modes
#
1
(
permalink
)
05-03-2006, 09:56 AM
Procrastinator
Posts: n/a
How to use user function in SELECT query
This doesn't work
Declare
bignum number ;
function sqr(n number) return number
is
begin
return n * n ;
end;
begin
-- dbms_output.put_line(sqr(3));
select sqr(3) into bignum from dual;
end;
Procrastinator
«
Previous Thread
|
Next Thread
»
Thread Tools
Search this Thread
Show Printable Version
Email this Page
Search this Thread
:
Advanced Search
Display Modes
Linear Mode
Switch to Hybrid Mode
Switch to Threaded Mode
Posting Rules
You
may not
post new threads
You
may not
post replies
You
may not
post attachments
You
may not
edit your posts
vB code
is
On
Smilies
are
On
[IMG]
code is
On
HTML code is
Off
Trackbacks
are
On
Pingbacks
are
On
Refbacks
are
On
All times are GMT. The time now is
02:00 PM
.
Free Web Hosting
|
Free Scripts Directory
|
Free Software Downloads
|
Paracoda Network
|
Targeted Traffic
|
SEO Consulting UK
|
Web Page Hosting
|
Optel.net
|
Mirroraty.org
|
Cruised Web Directory
Contact Us
-
News Archives
-
Top
LinkBack
LinkBack URL
About LinkBacks
Bookmark & Share
Digg this Thread!
Add Thread to del.icio.us
Bookmark in Technorati
Furl this Thread!
LinkBacks Enabled by vBSEO 3.0.0 © 2007, Crawlability, Inc.