Results for CASE


1 to 20 of 3008 results. Prev  Next
Results per page:   20  | 40 | 60


User's Guide and Reference, 10g Release 1 (10.1)

CASE Statement

CASE StatementThe CASE statement chooses from a sequence of conditions, and executes a corresponding statement … . The CASE statement evaluates a single expression and compares it against several potential values, or … searched_case_statement::= [ > ] CASE { WHEN boolean_expression THEN {statement;}... }... [ ELSE {statement … ;}... ] END CASE

SQL Reference, 10g Release 1 (10.1)

CASE Expressions

CASE ExpressionsCASE expressions let you use IF... THEN... ELSE logic in SQL statements without having to invoke … of the illustration else_clause.gif In a simple CASE expression, Oracle searches for the first WHEN … else_expr. In a searched CASE expression, Oracle searches from left to right until it finds an occurrence … ELSE clause exists,

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

CASE ExpressionsOracle now supports simple and searched CASE statements. CASE statements are similar in purpose to … arguments. For a workaround to this limit, see Oracle Database SQL Reference. Example 21-20 CASE … less than $2000, you want the query to use $2000 instead. Without a CASE statement, you would have … also add to

User's Guide and Reference, 10g Release 1 (10.1)

2 Fundamentals of the PL/SQL Language

CASE ExpressionsA CASE expression selects a result from one or more alternatives, and returns the result. Although … part of a larger statement, such as an assignment or a procedure call. The CASE expression uses a … selector, an expression whose value determines which alternative to return. A CASE expression has the … following form: CASE

Pro*FORTRAN® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

Writing a Pro*FORTRAN Program

Case-sensitivityThough the standard FORTRAN character set excludes lowercase alpha characters, many compilers allow them in identifiers, comments, and quoted literals.

Application Developer's Guide, 10g Release 1 (10.1)

9 Working With a Thesaurus

9.1.3 Case-insensitive ThesauriIn a case-insensitive thesaurus, terms are stored in all-uppercase, regardless of the case in which … they were entered. The ctxload program loads a thesaurus case-insensitive by default. When creating … a thesaurus with CTX_THES. CREATE_THESAURUS, the thesaurus is created case-insensitive by default … . In addition,

User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Using the CASE StatementLike the IF statement, the CASE statement selects one sequence of statements to execute. However … , to select the sequence, the CASE statement uses a selector rather than multiple Boolean expressions … alternatives.) To compare the IF and CASE statements, consider the following code that outputs … ', or 'F'. Let us rewrite the

Pro*PL/1® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

3 Running the Pro*PL/1 Precompiler

3.2.2 Case SensitivityHowever, if your operating system is case sensitive, like UNIX, you must specify filename values

Utilities, 10g Release 1 (10.1)

12 SQL*Loader Case Studies

Running Case Study 9Take the following steps to run the case study. Start SQL*Plus as scott/tiger by entering the … , execute the SQL script for this case study, as follows: SQL> @ulcase9 This prepares and populates tables … for the case study and then returns you to the system prompt. At the system prompt, invoke SQL … *Loader and run the case

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

2 Precompiler Concepts

2.2.2 Case-InsensitivityCOBOL statements are case-insensitive. The precompiler accepts both upper- and lower-case tokens.

Utilities, 10g Release 1 (10.1)

12 SQL*Loader Case Studies

Running Case Study 8Take the following steps to run the case study. Start SQL*Plus as scott/tiger by entering the … , execute the SQL script for this case study, as follows: SQL> @ulcase8 This prepares and populates tables … for the case study and then returns you to the system prompt. At the system prompt, invoke SQL … *Loader and run the case

Utilities, 10g Release 1 (10.1)

12 SQL*Loader Case Studies

Case Study FilesThe distribution media for SQL*Loader contains files for each case: Control files (for example … sample data for the case study is contained in the control file, then there will be no. dat file for … that case. If there are no special setup steps for a case study, there may be no. sql file for that … case.

Utilities, 10g Release 1 (10.1)

12 SQL*Loader Case Studies

Running Case Study 1Take the following steps to run the case study. Start SQL*Plus as scott/tiger by entering the … , execute the SQL script for this case study, as follows: SQL> @ulcase1 This prepares and populates tables … for the case study and then returns you to the system prompt. At the system prompt, invoke SQL … *Loader and run the case

Application Developer's Guide, 10g Release 1 (10.1)

4 Querying

4.1.8 Case-Sensitive SearchingOracle Text supports case-sensitivity for word and ABOUT queries. 4.1.8.1 Word Queries Word queries … are case-insensitive by default. This means that a query on the term dog returns the rows in your … text table that contain the word dog, Dog, or DOG. You can enable case-sensitive searching by … enabling the mixed_case attribute

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

14 Precompiler Options

14.1.1 Case-Sensitivity… However, if your operating system is case-sensitive (as in UNIX for example) you must specify filename … objects, such as filenames, are not case-sensitive. In the examples in this guide, option names are … written in upper case or lower case, and option values are usually in lower case. Filenames,

Platform Guide for Windows, 10g Release 1 (10.1)

2 Database Tools on Windows

2.3.2 Case Study FilesThe distribution media for SQL*Loader contains case study files for control files, datafiles, and

Utilities, 10g Release 1 (10.1)

12 SQL*Loader Case Studies

Running Case Study 2Take the following steps to run the case study. If you have already run case study 1, you can skip … to Step 3 because the ulcase1. sql script handles both case 1 and case 2. Start SQL*Plus as scott … . At the SQL prompt, execute the SQL script for this case study, as follows: SQL> @ulcase1 This

Utilities, 10g Release 1 (10.1)

12 SQL*Loader Case Studies

Running Case Study 7Take the following steps to run the case study. Start SQL*Plus as scott/tiger by entering the … , execute the SQL script for this case study, as follows: SQL> @ulcase7s This prepares and populates tables … for the case study and then returns you to the system prompt. At the system prompt, invoke SQL … *Loader and run the case

Utilities, 10g Release 1 (10.1)

12 SQL*Loader Case Studies

Running Case Study 11Take the following steps to run the case study. Start SQL*Plus as scott/tiger by entering the … , execute the SQL script for this case study, as follows: SQL> @ulcase11 This prepares the table emp for … the case study and then returns you to the system prompt. At the system prompt, invoke SQL*Loader and … run the case

Utilities, 10g Release 1 (10.1)

12 SQL*Loader Case Studies

Running Case Study 4Take the following steps to run the case study. Start SQL*Plus as scott/tiger by entering the … , execute the SQL script for this case study, as follows: SQL> @ulcase4 This prepares and populates tables … for the case study and then returns you to the system prompt. At the system prompt, invoke SQL … *Loader and run the case





Was this page helpful?

Integrated Cloud Applications & Platform Services