Results for AS


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


Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Cursor Variables as Subprogram ParametersYou can use a cursor variable as a subprogram parameter, which makes it useful for passing query … , using them as subprogram parameters increases the likelihood of subprogram parameter aliasing … Variable Parameters\". When declaring a cursor variable as the formal parameter of a subprogram: If … Open Cursor Variable for One

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Cursor Variables as Host VariablesYou can use a cursor variable as a host variable, which makes it useful for passing query results … set. To use a cursor variable as a host variable, declare the cursor variable in the host … environment and then pass it as an input host variable (bind variable) to PL/SQL. Host cursor variables are … client program declares a

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Optimization and Tuning

Pipelined Table Functions as Transformation FunctionsA pipelined table function with a cursor variable parameter can serve as a transformation function

Database Performance Tuning Guide, 11g Release 2 (11.2)

SQL Tuning Overview

16.5.9 Visiting Data as Few Times as Possibleefficient to run the entire query in a single statement. Each number is calculated as one column. The

Warehouse Builder OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBSTART

ASThe execution's Audit Name.

Warehouse Builder OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBDEPLOY

ASPerform the Deployment to a File System.

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Files, Directories, and Templates

Filename Form Reference to File? Single-file Creation? Multiple File Creation? Created as OMF?Fully qualified file name Yes No No No Alias file name Yes Yes No No Alias with template file name No Yes No No Incomplete file name No Yes Yes Yes Incomplete file name with template No Yes Yes Yes

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Language Fundamentals

Assigning Values to Variables as Parameters of a SubprogramIf you pass a variable to a subprogram as an OUT or IN OUT parameter, and the subprogram assigns a … finishes running. Example 2-26 Assigning Value to Variable as IN OUT Subprogram Parameter DECLARE

Database Utilities, 11g Release 2 (11.2)

Original Import

Invoking Import As SYSDBASYSDBA is used internally and has specialized functions; its behavior is not the same as for … generalized users. Therefore, you should not typically need to invoke Import as SYSDBA, except in the

Database Utilities, 11g Release 2 (11.2)

Original Export

Invoking Export as SYSDBASYSDBA is used internally and has specialized functions; its behavior is not the same as for … generalized users. Therefore, you should not typically need to invoke Export as SYSDBA except in the

Database Installation Guide for Linux, 11g Release 2 (11.2)

Oracle Database Preinstallation Tasks

2.2 Logging In to the System as rootBefore you install the Oracle software, you must complete several tasks as the root user. To log in … as the root user, complete one of the following procedures: Note: Unless you intend to complete a … : $ telnet fully_qualified_remote_host_name If you are not logged in as the root user, then enter the … X terminal ( xterm ).

XML DB Developer's Guide, 11g Release 2 (11.2)

Viewing Existing Data as XML

Viewing Existing Data as XMLPart IV Viewing Existing Data as XML Part IV of this manual introduces you to ways you can view … your existing data as XML. It contains the following chapters: Chapter 18, \"Generating XML Data from

Database Clusterware Administration and Deployment Guide, 11g Release 2 (11.2)

Making Applications Highly Available Using Oracle Clusterware

Registering an Application as a ResourceThis section presents examples of the procedures for registering an application as a resource in … Oracle Clusterware. The procedures instruct you how to add an Apache Web server as a resource to

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Performing User-Managed Database Flashback and Recovery

Deciding Whether to Allow Recovery to Mark as Corrupt Blocks: Phase 3it is allowed to mark as corrupt the data block causing the problem. The alert log contains … database can proceed with recovery if it is allowed to mark the problem block as corrupt … SYSTEM tablespace, marking the block as corrupt can eventually prevent you from opening the recovered … invoke trial recovery, as

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Using Flat Files as Sources or Targets

Describing a Flat Fileis not a viable solution. You can also use this wizard to create a flat file for use as a target in

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Using Flat Files as Sources or Targets

Multiple DefinitionsGroup Fields As seen in the section on Data Hierarchy, fields can be organized in groups. These … 9. 05 EMP-DEPT PIC 999. In the above example, the EMP-ID field is defined as a 6 digit numeric field … . A redefinition is provided dividing the field into two fields: EMP-ID-GROUP is defined as the … first two digits of the EMP-ID

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Using Flat Files as Sources or Targets

Importing Metadataa flat file module as described in \"Creating Flat File Modules\". Provide the location details of … the import as well. To specify a template file, select a file from the Copy Flat File Properties … , the file is defined as fixed format (not delimited) with the following properties: Skip 0 records Use … first row as

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Using Flat Files as Sources or Targets

Synchronizing an External Table Definition with a Record in a FileOracle Warehouse Builder enables you to update the external table definition with the metadata changes made to the file associated with the external table. You do this by synchronizing the external table with the source file. To synchronize an external table definition with a record in a file: In the Projects Navigator, right-click the external table to synchronize and select Synchronize. Oracle Warehouse

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Using Flat Files as Sources or Targets

About Metadata for Flat Filestypes. Before you use a flat file as source, it is desirable to define the metadata of that flat

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Using Flat Files as Sources or Targets

About Flat File Modules and LocationsYou can create flat file modules in your project that store metadata for source and target files. Each flat file module must be associated with a metadata and data location. When you specify a location for a module, both metadata location and data location point to the same location. You can specify different locations for the metadata and the data by editing the module.





Was this page helpful?

Integrated Cloud Applications & Platform Services