RE: Literal SQL and sys.dual

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Wed, 03 Apr 2002 07:53:28 -0800
Message-ID: <F001.00439FC2.20020403075328@fatcity.com>

TRy something like this ...

CREATE OR REPLACE PACKAGE My_Dynamic_Stuff IS

   v_result NUMBER;
--

PROCEDURE eval_this (pi_string IN VARCHAR2); END My_Dynamic_Stuff;
/

CREATE OR REPLACE PACKAGE BODY My_Dynamic_Stuff IS
--

PROCEDURE eval_this (pi_string IN VARCHAR2) IS BEGIN
RTRIM(pi_string,';') || '; end;';
END eval_this;
--

END My_Dynamic_Stuff;
/

Here is a test ...

SQL> get raj_test
  1 declare
  2 my_str varchar2(100);
  3 begin

  4     dbms_output.enable;
  5     my_dynamic_stuff.eval_this('1 + 1 + 1 + 1');
  6     dbms_output.put_line ('"1 + 1 + 1 + 1" evaluates to : ' ||
to_char(my_dynamic_stuff.v_result));
  7     --
  8     my_dynamic_stuff.eval_this('1 + (2 - 3)/4 + 5 / 4 + (6 + 7) / ( 5 +
5 + 0)');
  9     dbms_output.put_line ('"1 + (2 - 3)/4 + 5 / 4 + (6 + 7) / ( 5 + 5 +

0)" evaluates to : ' || to_char(my_dynamic_stuff.v_result));  10* end;

SQL> @raj_test

"1 + 1 + 1 + 1" evaluates to : 4
"1 + (2 - 3)/4 + 5 / 4 + (6 + 7) / ( 5 + 5 + 0)" evaluates to : 3.3

PL/SQL procedure successfully completed.

SQL> HTH some
Raj

---

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 03 2002 - 09:53:28 CST