.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

<< < … 13 14 15 16 17 18 19 20 21 22 23 … > >>   Sort: Date

What Is an Oracle Tablespace
What Is an Oracle Tablespace? - Oracle DBA FAQ - Oracle Basic Concepts An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes. Each tablespace in an Oracle database consists of... 2007-04-16, 4906👍, 0💬

What Is the Simplest Tool to Run Commands on Oracle Servers
What Is the Simplest Tool to Run Commands on Oracle Servers? - Oracle DBA FAQ - Loading and Exporting Data The simplest tool to connect to an Oracle server and run commands to manage data is SQL*Plus. It is an Oracle database client tool that works as a command-line user interface to the database se... 2007-04-30, 4903👍, 0💬

How To Look at the Current SQL*Plus System Settings
How To Look at the Current SQL*Plus System Settings? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want to see the current values of SQL*Plus system settings, you can use the SHOW command as shown in the following tutorial exercise: SQL> SHOW AUTOCOMMIT autocommit OFF S... 2007-04-29, 4899👍, 0💬

How To Create a new Oracle Data File
How To Create a new Oracle Data File? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files There is no dedicated statement to create a data file. Data files are created as part of statements that manages other data structures, like tablespace and database. 2007-05-03, 4897👍, 0💬

What Is a Function
What Is a Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions 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 req... 2007-04-26, 4897👍, 0💬

How To Connect to the Server with User Account: SYS
How To Connect to the Server with User Account: SYS? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges SYS is a very special user account. It has been associated with the highest privilege call SYSDBA. Normally, you should not connect to the server with SYS. But if you want to ... 2007-05-02, 4895👍, 0💬

How To Create a Table Index
How To Create a Table Index? - Oracle DBA FAQ - Understanding SQL DDL Statements If you have a table with a lots of rows, and you know that one of the columns will be used often a search criteria, you can add an index for that column to in improve the search performance. To add an index, you can use... 2007-04-22, 4895👍, 0💬

What Is the Relation of a User Account and a Schema
What Is the Relation of a User Account and a Schema? - Oracle DBA FAQ - Oracle Basic Concepts User accounts and schemas have a one-to-one relation. When you create a user, you are also implicitly creating a schema for that user. A schema is a logical container for the database objects (such as table... 2007-04-21, 4891👍, 0💬

What Is a User Account
What Is a User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges A user account is identified by a user name and defines the user's attributes, including the following: Password for database authentication Privileges and roles Default tablespace for database objects De... 2007-05-02, 4883👍, 0💬

Where Are the Settings Stored for Each Instance
Where Are the Settings Stored for Each Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Settings for each instance are stored in a file called Server Parameter File (SPFile). Oracle supports two types of parameter files, Text type, and Binary type. parameter files sho... 2007-04-25, 4883👍, 0💬

What Do You Think about PL/SQL
What Do You Think about PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL After following through the tutorials in the FAQ collection, you probably agree that PL/SQL is indeed a general purpose database programming language. PL/SQL is a natural extension of SQL. It is very useful for DBA to automate... 2007-04-26, 4881👍, 0💬

What Is a Static Data Dictionary
What Is a Static Data Dictionary? - Oracle DBA FAQ - Oracle Basic Concepts Data dictionary tables are not directly accessible, but you can access information in them through data dictionary views. To list the data dictionary views available to you, query the view DICTIONARY. Many data dictionary tab... 2007-04-22, 4881👍, 0💬

What Is Input Buffer in SQL*Plus
What Is Input Buffer in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Input buffer is a nice feature of the command-line SQL*Plus tool. It allows you to revise a multiple-line command and re-run it with a couple of simple commands. By default, input buffer is always ... 2007-04-29, 4880👍, 0💬

Can Group Functions Be Used in the ORDER BY Clause
Can Group Functions Be Used in the ORDER BY Clause? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If the query output is aggregated as groups, you can sort the groups by using group functions in the ORDER BY clause. The following statement returns how many employees are having the sam... 2007-04-20, 4879👍, 0💬

What Is a Dynamic Performance View
What Is a Dynamic Performance View? - Oracle DBA FAQ - Oracle Basic Concepts Oracle contains a set of underlying views that are maintained by the database server and accessible to the database administrator user SYS. These views are called dynamic performance views because they are continuously upda... 2007-04-22, 4877👍, 0💬

How To Use Subqueries in the FROM clause
How To Use Subqueries in the FROM clause? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you have a query returning many rows of data, and you want to perform another query on those rows, you can put the first query as a subquery in the FROM clause of the second query. The following... 2007-04-19, 4875👍, 0💬

What happened to SQL*Menu?
What happened to SQL*Menu? From Forms V4.5, SQL*Menu is fully integrated into Oracle Forms. Application menus can be added to your application by creating Menu Modules (*.MMB) and generate it to Menu Module Executables (*.MMX). 2011-04-26, 4868👍, 0💬

How To Bring a Tablespace Offline
How To Bring a Tablespace Offline? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you want to stop users using a tablespace, you can bring it offline using the ALTER TABLESPACE ... OFFLINE statement as shown in the following script: SQL> connect HR/fyicenter Connected. SQL> CREATE ... 2007-05-03, 4868👍, 0💬

What Is a Table Index
What Is a Table Index? - Oracle DBA FAQ - Oracle Basic Concepts Index is an optional structure associated with a table that allow SQL statements to execute more quickly against a table. Just as the index in this manual helps you locate information faster than if there were no index, an Oracle Databa... 2007-04-22, 4862👍, 0💬

What Types of Commands Can Be Executed in SQL*Plus
What Types of Commands Can Be Executed in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool There are 4 types of commands you can run at the SQL*Plus command line prompt: 1. SQL commands - Standard SQL statements to be executed on target database on the Oracle server. Fo... 2007-04-29, 4849👍, 0💬

How To End the Current Transaction
How To End the Current Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management There are several ways the current transaction can be ended: Running the COMMIT statement will explicitly end the current transaction. Running the ROLLBACK statement will explicitly end the current transa... 2007-04-18, 4842👍, 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, 4839👍, 0💬

How To Drop an Existing Table
How To Drop an Existing Table? - Oracle DBA FAQ - Understanding SQL DDL Statements If you want to delete an existing table and its data rows, you can use the DROP TABLE statement as shown in this script: SQL> connect HR/fyicenter Connected. SQL> CREATE TABLE emp_dept_10 2 AS SELECT * FROM employees ... 2007-04-22, 4825👍, 0💬

How To Use LIKE Conditions
How To Use LIKE Conditions? - Oracle DBA FAQ - Understanding SQL Basics LIKE condition is also called pattern patch. There 3 main rules on using LIKE condition: '_' is used in the pattern to match any one character. '%' is used in the pattern to match any zero or more characters. ESCAPE clause is us... 2007-04-23, 4823👍, 0💬

<< < … 13 14 15 16 17 18 19 20 21 22 23 … > >>   Sort: Date

.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