Results for BETWEEN


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


Streams, 9i Release 2 (9.2.0.2)

Streams Staging and Propagation

Event Propagation Between QueuesYou can use Streams to configure event propagation between two queues, which may reside in … different databases. Streams uses job queues to propagate events. A propagation is always between a source … queue and a destination queue. Although propagation is always between two queues, a single queue may … . However, only one propagation

Oracle Database, 9i Release 2 (9.2.0.2)

Oracle9i Database Documentation Readme

Differences Between Documentation FormatsAs a result of publishing deadlines, the online versions of manuals in this library may contain updates or corrections that are not included in the printed books. Additionally, the HTML version of a manual may contain minor updates or corrections that do not appear in the PDF version.

Administrator's Guide, 9i Release 2 (9.2.0.2)

Managing Tablespaces

Transporting Tablespaces Between DatabasesThis section describes how to transport tablespaces between databases, and contains the following … Transportable Tablespaces Transporting Tablespaces Between Databases: A Procedure Object Behaviors Using Transportable Tablespaces

Oracle Database, 9i Release 2 (9.2.0.2)

Oracle Ultra Search APIs: Class Between

oracle.ultrasearch.query Class BetweenDETAIL:  FIELD |  CONSTR  |  METHOD oracle.ultrasearch.query Class Between java.lang.Object … | +--oracle.ultrasearch.query.Between public class Between extends java.lang.Object implements Query Find … documents that has an attribute value within a range. Between can be applied to Date attribute, or Number … attribute. Since:

Workflow Guide (Oracle Workflow Help), 9i Release 2 (9.2.0.2)

Mapping Between WF_EVENT_T and OMBAQ_TEXT_MSG (Oracle Workflow Help)

Mapping Between WF_EVENT_T and OMBAQ_TEXT_MSGmessages between systems. OMB queues require messages to be stored in a structure defined by a Java … called WF_EVENT_OMB_QH which you can use to translate between the standard Workflow WF_EVENT_T message

Replication Management API Reference, 9i Release 2 (9.2.0.2)

Managing Replication Objects and Queues

Determining Differences Between Replicated Tablesoptionally rectify, the differences between two tables when both sites are Oracle release 7.3 or higher.

Concepts, 9i Release 2 (9.2.0.2)

Tablespaces, Datafiles, and Control Files

Transport of Tablespaces Between Databasesthe tablespace between databases, or you can unplug a tablespace from one Oracle database and plug … it into another Oracle database, moving the tablespace between databases on the same platform … transport tablespaces only between Oracle databases that use the same character set and that run on

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

Frequently Asked Questions about LOBs

Converting Between Different LOB TypesIs Implicit LOB Conversion Between Different LOB Types Allowed? Question There are no implicit LOB … conversions between different LOB types? For example, in PL/SQL, I cannot use: INSERT INTO t VALUES

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

JPublisher Concepts

JPublisher Compatibility Between JDK Versionsof.sqlj files that are completely compatible between JDK 1.1.x and JDK 1.2.x or higher. (With this … i JPublisher default behavior, and is what makes translated.java code incompatible between JDK 1.1

Label Security Administrator's Guide, 9i Release 2 (9.2.0.2)

Advanced Topics in Oracle Label Security

Analyzing the Relationships Between LabelsThis section describes relationships between labels. It contains these topics: Dominant and

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Defining Data Objects, 6 of 11

Example: Relation Between Two Dimensionsbetween them to associate each city with the state that it is in. Assume that the state.city relation was

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

Interaction Between PL/SQL and Oracle

Overview of SQL Support in PL/SQLManaging Cursors Separating Cursor Specs and Bodies with Packages

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

Interaction Between PL/SQL and Oracle

Overview of Explicit CursorsThe set of rows returned by a query can consist of zero, one, or multiple rows, depending on how many rows meet your search criteria. When a query returns multiple rows, you can explicitly declare a cursor to process the rows. Moreover, you can declare a cursor in the declarative part of any PL/SQL block, subprogram, or package. You use three commands to control a cursor: OPEN, FETCH, and CLOSE. First,

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

Interaction Between PL/SQL and Oracle

Using Cursor AttributesEvery explicit cursor and cursor variable has four attributes: %FOUND, %ISOPEN %NOTFOUND, and %ROWCOUNT. When appended to the cursor or cursor variable, these attributes return useful information about the execution of a data manipulation statement. You can use cursor attributes in procedural statements but not in SQL statements.

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

Interaction Between PL/SQL and Oracle

Ending TransactionsA good programming practice is to commit or roll back every transaction explicitly. Whether you issue the commit or rollback in your PL/SQL program or in the host environment depends on the flow of application logic. If you neglect to commit or roll back a transaction explicitly, the host environment determines its final state. For example, in the SQL*Plus environment, if your PL/SQL block does not

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

Interaction Between PL/SQL and Oracle

Calling Autonomous Functions from SQLA function called from SQL statements must obey certain rules meant to control side effects. (See \"Controlling Side Effects of PL/SQL Subprograms\".) To check for violations of the rules, you can use the pragma RESTRICT_REFERENCES. The pragma asserts that a function does not read or write database tables or package variables. (For more information, See Oracle9i Application Developer's Guide - Fundamentals.)

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

Interaction Between PL/SQL and Oracle

Using Cursor AttributesUsing Cursor Expressions

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

Interaction Between PL/SQL and Oracle

SQL PseudocolumnsPL/SQL recognizes the following SQL pseudocolumns, which return specific data items: CURRVAL, LEVEL, NEXTVAL, ROWID, and ROWNUM. Pseudocolumns are not actual columns in a table but they behave like columns. For example, you can select values from a pseudocolumn. However, you cannot insert into, update, or delete from a pseudocolumn. Also, pseudocolumns are allowed in SQL statements, but not in procedural

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

Interaction Between PL/SQL and Oracle

Using Cursor Variablespass cursor variables back and forth between an application and server through remote procedure calls (RPCs).

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

Interaction Between PL/SQL and Oracle

Cursor Variable Example: Master Table and Details TablesConsider the stored procedure below, which searches the database of a main library for books, periodicals, and tapes. A master table stores the title and category code (where 1 = book, 2 = periodical, 3 = tape) of each item. Three detail tables store category-specific information. When called, the procedure searches the master table by title, uses the associated category code to pick an OPEN-FOR statement,





Was this page helpful?

Integrated Cloud Applications & Platform Services