.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

How To Apply Filtering Criteria at Group Level
How To Apply Filtering Criteria at Group Level? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you want to return only specific groups from the query, you can apply filtering criteria at the group level by using the HAVING clause inside the GROUP BY clause. The following script give... 2007-04-20, 5091👍, 0💬

How To Run CREATE DATABASE Statement Again
How To Run CREATE DATABASE Statement Again? - Oracle DBA FAQ - Creating New Database Instance Manually After cleaning up the results of a previously failed CREATE DATABASE statement, you can run the CREATE DATABASE statement again as shown below: SQL> @$ORACLE_HOME\config\scripts\c reate_database_fyi... 2007-04-23, 5086👍, 0💬

What Is a Database Table
What Is a Database Table? - Oracle DBA FAQ - Oracle Basic Concepts A database table is a basic unit of data logical storage in an Oracle database. Data is stored in rows and columns. You define a table with a table name, such as employees, and a set of columns. You give each column a column name, su... 2007-04-21, 5085👍, 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, 5083👍, 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, 5081👍, 0💬

How To Drop a Tablespace
How To Drop a Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you have an existing tablespace and you don't want it anymore. You can delete a tablespace by using the DROP TABLESPACE statement as shown in the example below: SQL> CREATE TABLESPACE my_space 2 DATAFILE '/tem... 2007-05-03, 5080👍, 0💬

How To Drop an Index
How To Drop an Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you don't need an existing index any more, you should delete it with the DROP INDEX statement. Here is an example SQL script: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(8... 2007-05-02, 5078👍, 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, 5078👍, 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, 5077👍, 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, 5072👍, 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, 5070👍, 0💬

How To Define a Variable of a Specific RECORD Type
How To Define a Variable of a Specific RECORD Type? - Oracle DBA FAQ - Working with Database Objects in PL/SQL Once you have your specific RECORD type defined, you can define new variables with this specific RECORD type like any other data type. In the sample script below, several variables are defi... 2007-04-27, 5069👍, 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, 5067👍, 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, 5064👍, 0💬

How To Create Additional Tablespaces for an New Database
How To Create Additional Tablespaces for an New Database? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 8. Creating additional tablespaces can be done by using the CREATE TABLESPACE statement as shown in the following sample script: SQL> CREATE TABLESPACE users 2 DATAFILE '... 2007-04-23, 5061👍, 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, 5055👍, 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, 5052👍, 0💬

What Is a User Account
What Is a User Account? - Oracle DBA FAQ - Oracle Basic Concepts 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 Default temporary tablespace for ... 2007-04-21, 5043👍, 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, 5032👍, 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, 5031👍, 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, 5023👍, 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, 5015👍, 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, 5004👍, 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, 5000👍, 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