Αποτελέσματα Αναζήτησης
Oracle CASE expression allows you to add if-else logic to SQL statements without having to call a procedure. The CASE expression evaluates a list of conditions and returns one of the multiple possible results. You can use a CASE expression in any statement or clause that accepts a valid expression.
6 Μαΐ 2015 · You should use a (left) outer join to solve such case. NVL/COALESCE will take care of replacing NULL by some hard coded value. Something like that: SELECT T...., T...., NVL(USR.NAME, 'NO PR_USER' ) FROM USER T LEFT JOIN USER USR ON USR.USER_ID=T.PR_USER_ID
7 Δεκ 2023 · How to use CASE for IF-THEN logic in SQL SELECT. If you want to see the grade for each exam, select the case expression like a regular column: It’s a good idea to give the expression an alias. This is particularly important if the case is in a subquery.
I need to do this: SELECT COLUMN1, COLUMN2, CASE SOMETHING WHEN 0 THEN 'SOMETHING' ELSE CASE SOMETHING1 WHEN 'SOMETHING2' THEN (Here I need my value from other table) ELSE ... E...
A database connection is a SQL Developer object that specifies the necessary information for connecting to a specific database, as a specific user of that database. You must have at least one database connection (existing, created, or imported) to use SQL Developer.
15 Μαρ 2021 · WITH x AS ( SELECT level+1 a,level+2 b,level+3 c,level+4 d,level+5 e FROM dual CONNECT BY level <= 10) SELECT CASE a+b+c+d+e WHEN <30 THEN 'Below 30' WHEN <60 THEN 'Below 60' WHEN IS NULL THEN 'NULL' ELSE 'Above' END FROM x;
In a simple CASE expression, Oracle Database searches for the first WHEN... THEN pair for which expr is equal to comparison_expr and returns return_expr. If none of the WHEN... THEN pairs meet this condition, and an ELSE clause exists, then Oracle returns else_expr. Otherwise, Oracle returns null.
