.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < … 135 136 137 138 139 140 141 142 143 144 145 … > >>   Sort: Rank

What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema
What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to delete rows from tables of someone else's schema, he/she needs the DELETE ANY TABLE privilege. The following tutorial exercise gives... 2007-05-01, 5571👍, 0💬

What Is the Data Pump Export Utility
What Is the Data Pump Export Utility? - Oracle DBA FAQ - Loading and Exporting Data Oracle Data Pump Export utility is a standalone programs that allows you to export data objects from Oracle database to operating system files called dump file set, which can be imported back to Oracle database only ... 2007-05-01, 5460👍, 0💬

How To Find Out What Privileges a User Currently Has
How To Find Out What Privileges a User Currently Has? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges Privileges granted to users are listed in two system views: DBA_SYS_PRIVS, and USER_SYS_PRIVS. You can find out what privileges a user currently has by running a query on tho... 2007-05-01, 5917👍, 0💬

What Is the Data Pump Import Utility
What Is the Data Pump Import Utility? - Oracle DBA FAQ - Loading and Exporting Data Oracle Data Pump Import utility is a standalone programs that allows you to import data objects from an Oracle dump file set into Oracle database. Oracle dump file set is written in a proprietary binary format by the... 2007-05-01, 8092👍, 0💬

What Is PL/SQL Language Case Sensitive
What Is PL/SQL Language Case Sensitive? - Oracle DBA FAQ - Understanding PL/SQL Language Basics PL/SQL language is not case sensitive: Reserved words are not case sensitive. For example: CASE and Case are identical. Variable names and other names are not case sensitive. For example: TOTAL_SALARY and... 2007-05-01, 5817👍, 0💬

How To Place Comments in PL/SQL
How To Place Comments in PL/SQL? - Oracle DBA FAQ - Understanding PL/SQL Language Basics There are two ways to place comments into PL/SQL codes: SQL Statement Style: Starts you comment any where in the line but prefixed with '--'. The comment ends at the end of the line. C Language Style: Starts you... 2007-05-01, 5995👍, 0💬

How To Load Data from External Tables to Regular Tables
How To Load Data from External Tables to Regular Tables? - Oracle DBA FAQ - Loading and Exporting Data Once you have your data entered in a text file, and an external table defined to this text file, you can easily load data from this text file to a regular table. The following tutorial exercise sho... 2007-05-01, 5638👍, 0💬

How To Run Queries on External Tables
How To Run Queries on External Tables? - Oracle DBA FAQ - Loading and Exporting Data If you have an external table defined as a text file with the ORACLE_LOADER driver, you can add data to the text file, and query the text file through the external table. By default, data fields in the text file sho... 2007-05-01, 4981👍, 0💬

What Are the Types PL/SQL Code Blocks
What Are the Types PL/SQL Code Blocks? - Oracle DBA FAQ - Understanding PL/SQL Language Basics There are 3 types of PL/SQL code blocks: Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers. Stored Program Unit - A block of code... 2007-05-01, 5911👍, 0💬

What Is an Anonymous Block
What Is an Anonymous Block? - Oracle DBA FAQ - Understanding PL/SQL Language Basics An anonymous block is a PL/SQL code block with no name. It consists of three parts: Declaration Part - Defining local variables and local procedures. Declaration part is optional. Execution Part - Defining execution ... 2007-04-30, 6351👍, 0💬

How To Define an External Table with a Text File
How To Define an External Table with a Text File? - Oracle DBA FAQ - Loading and Exporting Data You can use the CREATE TABLE statement to create external tables. But you need to use ORGANIZATION EXTERNAL clause to specify the external file location and the data access driver. The tutorial exercise b... 2007-04-30, 5478👍, 0💬

What Is a Directory Object
What Is a Directory Object? - Oracle DBA FAQ - Loading and Exporting Data A directory object is a logical alias for a physical directory path name on the operating system. Directory objects can be created, dropped, and granted access permissions to different users. The following tutorial exercise sh... 2007-04-30, 5284👍, 0💬

What Is a Named Program Unit
What Is a Named Program Unit? - Oracle DBA FAQ - Understanding PL/SQL Language Basics A named program unit is a PL/SQL code block with an name. It consists of three parts: Declaration Part - Defining the program unit name, calling parameters, local variables and local procedures. Declaration part is... 2007-04-30, 6159👍, 0💬

What Is a Procedure
What Is a Procedure? - Oracle DBA FAQ - Understanding PL/SQL Language Basics A procedure is a named program unit. It consists of three parts: Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required. Execution Part - Defin... 2007-04-30, 6132👍, 0💬

What Are the Restrictions on External Table Columns
What Are the Restrictions on External Table Columns? - Oracle DBA FAQ - Loading and Exporting Data When creating external table columns, you need to watch out some restrictions: "PRIMARY KEY" is not allowed. "NOT NULL" is not allowed. "DEFAULT value" is not allowed. 2007-04-30, 5617👍, 0💬

How To Load Data through External Tables
How To Load Data through External Tables? - Oracle DBA FAQ - Loading and Exporting Data If you have data stored in external files, you can load it to database through an external table by the steps below: Create an external table with columns matching data fields in the external file. Create a regul... 2007-04-30, 5248👍, 0💬

What Is a Function
What Is a Function? - Oracle DBA FAQ - Understanding PL/SQL Language Basics A function is a named program unit. It consists of three parts: Declaration Part - Defining the function name, calling parameters, return value type, local variables and local procedures. Declaration part is required. Execut... 2007-04-30, 5618👍, 0💬

How To Load Data with SQL*Loader
How To Load Data with SQL*Loader? - Oracle DBA FAQ - Loading and Exporting Data Let's say you have a table defined as: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(80) NOT NULL, birth_date DATE NOT NULL, social_number VARCHAR(80) UNIQUE NOT NULL)... 2007-04-30, 5879👍, 0💬

How To Declare a Local Variable
How To Declare a Local Variable? - Oracle DBA FAQ - Understanding PL/SQL Language Basics A local variable can be defined in the declaration part with a declaration statement, which is a variable name followed a data type identifier. Below are some examples of declaration statements: PROCEDURE proc_v... 2007-04-30, 6482👍, 0💬

How To Initialize Variables with Default Values
How To Initialize Variables with Default Values? - Oracle DBA FAQ - Understanding PL/SQL Language Basics There are two ways to assign default values to variables at the time of declaration: Using key word DEFAULT - Appending "DEFAULT value" to the end of declaration statements. Using assignment oper... 2007-04-30, 6321👍, 0💬

What Is an External Table
What Is an External Table? - Oracle DBA FAQ - Loading and Exporting Data An external table is a table defined in the database with data stored outside the database. Data of an external table is stored in files on the operating systems. Accessing data of external tables are done through data access d... 2007-04-30, 5770👍, 0💬

What Are the Arithmetic Operations
What Are the Arithmetic Operations? - Oracle DBA FAQ - Understanding PL/SQL Language Basics There are 4 basic arithmetic operations on numeric values as shown in the following sample script: PROCEDURE proc_arithmetic AS addition NUMBER; subtraction NUMBER; multiplication NUMBER; division NUMBER; BEG... 2007-04-30, 5888👍, 0💬

How To Assign Values to Variables
How To Assign Values to Variables? - Oracle DBA FAQ - Understanding PL/SQL Language Basics You can use assignment statements to assign values to variables. An assignment statement contains an assignment operator ":=", which takes the value specified on the right to the variable on left. The script b... 2007-04-30, 5950👍, 0💬

What Is a SQL*Loader Control File
What Is a SQL*Loader Control File? - Oracle DBA FAQ - Loading and Exporting Data A SQL*Loader control file a text that defines how data files should be loaded into the database. It allows you to specify: Where is the input data file. The format of the input date file. The target table where the data... 2007-04-30, 5481👍, 0💬

<< < … 135 136 137 138 139 140 141 142 143 144 145 … > >>   Sort: Rank

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML