Results for CASE


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


Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

CASE Examplesalary is less than $2000, you want the query to use $2000 instead. With a CASE statement, you would … can also add to the development load. Using CASE expressions in the database without PL/SQL, this … query can be rewritten as: SELECT AVG(CASE when e.sal > 2000 THEN e.sal ELSE 2000 end) FROM emps e … ; Using a CASE

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Running the Pro*PL/I Precompiler

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

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Precompiler Options

Case Sensitivity… However, if your operating system is case sensitive, like UNIX, you must specify filename values

SQL Reference, 9i Release 2 (9.2.0.2)

Expressions, 5 of 14

CASE ExpressionsCASE expressions let you use IF... THEN... ELSE logic in SQL statements without having to invoke … searched_case_expression else_clause::= Text description of else_clause In a simple CASE expression … searched CASE expression, Oracle searches from left to right until it finds an occurrence of condition … arguments in a CASE

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Control Structures

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

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Fundamentals of PL/SQL

CASE ExpressionsA CASE expression selects a result from one or more alternatives, and returns the result. The CASE … expression uses a selector, an expression whose value determines which alternative to return. A CASE … expression has the following form: CASE selector WHEN expression1 THEN result1 WHEN expression2 … '; appraisal

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

CASE ExpressionsOracle now supports simple and searched CASE statements. CASE statements are similar in purpose to

Pro*Fortran, 9i Release 2 (9.2.0.2)

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.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 5 of 52

CASE StatementThe CASE statement selects a sequence of statements to execute. To select the sequence, the CASE … , in the searched CASE statement, multiple search conditions.

Pro*COBOLĀ® Programmer's Guide, 9i Release 2 (9.2.0.2)

Precompiler Concepts

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

Reference, 9i Release 2 (9.2.0.2)

CONTAINS Query Operators

Case-SensitivityTags and attribute names in path searching are case-sensitive. That is, dog INPATH (A) finds dog but does not find dog. Instead use dog INPATH (a)

Pro*COBOLĀ® Programmer's Guide, 9i Release 2 (9.2.0.2)

Precompiler Options

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,

Utilities, 9i Release 2 (9.2.0.2)

SQL*Loader Case Studies

10 SQL*Loader Case StudiesThe case studies in this chapter illustrate some of the features of SQL*Loader. These case studies … following sections: The Case Studies Case Study Files Tables Used in the Case Studies Checking the Results … of a Load References and Notes Case Study 1: Loading Variable-Length Data

Utilities, 9i Release 2 (9.2.0.2)

SQL*Loader Case Studies

The Case StudiesThis chapter contains the following case studies: Case Study 1: Loading Variable-Length Data … quotation marks. The data is found at the end of the control file. Case Study 2: Loading Fixed-Format Fields … : Loads data from a separate datafile. Case Study 3: Loading a Delimited, Free-Format File: Loads … end of

Utilities, 9i Release 2 (9.2.0.2)

SQL*Loader Case Studies

Tables Used in the Case StudiesThe case studies are based upon the standard Oracle demonstration database tables, emp and dept … , owned by scott / tiger. (In some case studies, additional columns have been added.)

Utilities, 9i Release 2 (9.2.0.2)

SQL*Loader Case Studies

Contents of Table dept(deptno NUMBER(2) NOT NULL, dname VARCHAR2(14), loc VARCHAR2(13))

Utilities, 9i Release 2 (9.2.0.2)

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

Utilities, 9i Release 2 (9.2.0.2)

SQL*Loader Case Studies

Control File for Case Study 3This control file loads the same table as in case 2, but it loads three additional columns … (projno NUMBER, loadseq NUMBER); The data is in a different format than in case 2. Some data is

Utilities, 9i Release 2 (9.2.0.2)

SQL*Loader Case Studies

Log File for Case Study 6The following is a portion of the log file: Control File: ulcase6.ctl Data File: ulcase6.dat Bad File: ulcase6.bad Discard File: none specified (Allow all discards) Number to load: ALL Number to skip: 0 Errors allowed: 50 Continuation: none specified Path used: Direct Table EMP, loaded from every logical record. Insert option in effect for this table: REPLACE Column Name Position Len Term Encl Datatype

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

LOBs Case Studies

Building a Multimedia RepositoryThis description has been extracted from an article by Samir S. Shah in Java Developer's Journal. Reprinted by permission of Java Developer's Journal. Toolset Used Jdeveloper 2.0 with JDK 1.1.7 Oracle 8.1.5 or higher JDBC Thin Driver Oracle8i (8.1.5) Enterprise server Java Web Server 2.0 Oracle intermedia 8.1.5. Platform: Windows 2000 Server Today building an information repository is essential for





Was this page helpful?

Integrated Cloud Applications & Platform Services