Return a value if no rows are found SQL
What actually happens when you run a SQL query that doesn’t return any rows? For example, think of a WHERE clause with the condition 1=2, which can never be fulfilled and therefore rows can...
Tagged: SQL Tips
Werbung / Advertisements
SQL Default Value if no row is returned
Sometimes default values are necassary. Normally you can use NVL or NVL2 when you get NULL values as return value. But it is also possible, that no row is returned. In this case, NVL...
Tune SQL Developer – Make SQL Developer faster
Oracle SQL Developer is slow and you want to tune SQL Developer? Or too slow for you? Then you should tune your Developer Tool. It is really easy and everyone can do it. First...
