Αποτελέσματα Αναζήτησης
For example, you can use the CASE expression in statements such as SELECT, UPDATE, or DELETE, and in clauses like SELECT, WHERE, HAVING, and ORDDER BY. Oracle CASE expression has two formats: the simple CASE expression and the searched CASE expression. Both formats support an optional ELSE clause.
PdfGen - An Oracle PL/SQL PDF Generator. Create an attractive report from a SQL query with capabilities similar to those available in sqlplus report generator, but with control over fonts, margins, page size, and orientation. (See samples directory for PDF files it produced.)
You can rewrite it to use the ELSE condition of a CASE: SELECT status, CASE status WHEN 'i' THEN 'Inactive' WHEN 't' THEN 'Terminated' ELSE 'Active' END AS StatusText FROM stage.tst
Oracle software is used within the industry. Chaim Katzis an Oracle Certified Professional who has worked with Oracle products since Oracle version 4. He specializes in database administration and PL/SQL development and, over the years, he has written numerous articles for various Oracle technical journals. He has taught Logo to children and ...
Description PL/SQL offers a CASE statement and CASE expression, which gives you a nice alternative to the traditional IF. The CASE expression is particularly nice, since you can use it inside a statement.
The syntax for the CASE statement in Oracle/PLSQL is: CASE [ expression ] WHEN condition_1 THEN result_1 WHEN condition_2 THEN result_2 ... WHEN condition_n THEN result_n ELSE result END Parameters or Arguments expression Optional. It is the value that you are comparing to the list of conditions.
SQL statements are the means by which programs and users access data in an Oracle database. The sections that follow show each SQL statement and its related syntax.
