PL/SQL Logical Operators evaluate whole function

Posted by Chris on Stack Overflow See other posts from Stack Overflow or by Chris
Published on 2010-03-09T11:19:53Z Indexed on 2010/03/09 11:21 UTC
Read the original article Hit count: 300

Filed under:

plsql

I know in C like languages logical operators are evaluated one at a time so:

false && really_expensive_function()

is doesn't result in the function being called (I can't remember the CS name for this). Does the same happen in PL/SQL or do I need to break the IF parts out to separate blocks?

Related posts about plsql

Iterating over files in PLSQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Using a PLSQL script, is it possible to iterate over binary files in a folder and insert them as a BLOB in Oracle 10g? Any examples would be appreciated. >>> More
plsql show query

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I have a small problem using oracle pl sql. I have a sql file with some cursor, etc, and the treatement fail but with no details. I have an idea about the problem (a function with parameters) but I would like to see the parameter for each call, to be able to debug, to see exactly with wich… >>> More
Get 2 recoeds from PLSQL Cursor

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Guys... my Question is short, I create a cursor to get some values from my table I want to get the current record of cursor (the fetched record) and the next record from the cursor without fetching it, cause I want to make a calculation over the current record and the next record. in traditional… >>> More
Get two records from PLSQL cursor

as seen on Stack Overflow - Search for 'Stack Overflow'
My question is short. I create a cursor to get some values from my table. I want to get the current record of cursor (the fetched record) and the next record from the cursor without fetching it, because I want to make a calculation over the current record and the next record. In traditional programming… >>> More
PLSQL: How to go about it

as seen on Stack Overflow - Search for 'Stack Overflow'
I searched for this topic on SO but I did not found any recommendations and so am asking it as I am new to PLSQL and want to understand it: What is best way to get started with PLSQL ? What are best online resources or books available out there for understand PLSQL which you would recommend ? Do… >>> More

Developer IT

PL/SQL Logical Operators evaluate whole function - Developer IT

PL/SQL Logical Operators evaluate whole function

plsql

Related posts about plsql

Iterating over files in PLSQL

plsql show query

Get 2 recoeds from PLSQL Cursor

Get two records from PLSQL cursor

PLSQL: How to go about it

Categories cloud