Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Function Update Table

Re: Function Update Table

From: Algis <algis_at_go2.pl>
Date: 17 Feb 2001 16:32:14 GMT
Message-ID: <904BBBB07algisgo2pl@213.25.200.9>

jonathan_at_jlcomp.demon.co.uk (Jonathan Lewis) napisano w <982413080.10828.0.nnrp- 09.9e984b29_at_news.demon.co.uk>:

>
>To do this, you need Oracle 8.1, and
>then you can use AUTONOMOUS transactions.
>These can be a little counter-intuitive in use,
>so think carefully when using them.
>
>--
>Jonathan Lewis
>Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
>Practical Oracle 8i: Building Efficient Databases
>Publishers: Addison-Wesley
>
>Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>
>
>
>Algis wrote in message <904B86027algisgo2pl_at_213.25.200.9>...
>>Hi
>>
>>Is it possible to update table calling function from SELECT
>>
>>SELECT function_name FROM DUAL;
>>
>>where Function my be:
>>
>>Function
>>...
>>Begin
>>UPDATE table_name SET column_name = 1234;
>>
>>Return result_name;
>>End function_name;
>>
>
>
>

OK
I will try this
Thanks for Help. Received on Sat Feb 17 2001 - 10:32:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US