Oracle: How to call a function from the SQL*Plus command line

If you would like to verify the result of a function call in Oracle SQL*Plus you could simply include it in a SQL select statement like this:

create or replace function testfunction(testparm IN number) return number is begin return(testparm); end testfunction;

SQL> select testfunction(123) from dual;
 
TESTFUNCTION(123)
-----------------
              123
 
SQL>

Über Stefan

Polyglot Clean Code Developer

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert

To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four 
    spaces will be stripped off, but all other whitespace
    will be preserved.
    
    Markdown is turned off in code blocks:
     [This is not a link](http://example.com)

To create not a block, but an inline code span, use backticks: 

Here is some inline `code`.

For more help see http://daringfireball.net/projects/markdown/syntax