<< < 14 15 16 17 18 19 20 21 22 23 24 > >>   Sort: Rank

How To Calculate Date and Time Differences
How To Calculate Date and Time Differences? - Oracle DBA FAQ - Understanding SQL Basics If you want to know how many years, months, days and seconds are there between two dates or times, you can use the date and time interval expressions: YEAR ... TO MONTH and DAY ... TO SECOND. The tutorial exercis...
2007-04-23, 6037👍, 0💬

How To Start a Specific Oracle Instance
How To Start a Specific Oracle Instance? - Oracle DBA FAQ - Creating New Database Instance Manually A simple way to start a specific Oracle instance is to start the instance with the PFILE option as shown in the following example: >.\bin\sqlplus /nolog SQL> CONNECT / AS SYSDBA Connected. SQL> STARTU...
2007-04-23, 5018👍, 0💬

How To Start an Oracle Instance
How To Start an Oracle Instance? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 6. Now you are ready to start the new Oracle Instance without any database. This instance will be used to create a database. Starting an instance without database can be done by using STARTUP NOM...
2007-04-23, 5182👍, 0💬

How To Use IN Conditions
How To Use IN Conditions? - Oracle DBA FAQ - Understanding SQL Basics An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE. Some examples are given in the script below: SELECT CASE WHEN 3 IN (1,2,3,5) THEN 'TRUE' ...
2007-04-23, 5207👍, 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, 4786👍, 0💬

How To Create a Server Parameter File
How To Create a Server Parameter File? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 5. The initialization parameter file is good to get an Oracle database instance started. But it is not ideal run an instance as production. You need to convert the initialization parameter ...
2007-04-23, 5052👍, 0💬

How To Connect the Oracle Server as SYSDBA
How To Connect the Oracle Server as SYSDBA? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 4. The best way to connect to the Oracle server as an administrator is to use SQL*Plus. You need to run SQL*Plus with /nolog option and use the CONNECT with blank user name, blank pass...
2007-04-23, 5067👍, 0💬

How To Use Regular Expression in Pattern Match Conditions
How To Use Regular Expression in Pattern Match Conditions? - Oracle DBA FAQ - Understanding SQL Basics If you have a pattern that is too complex for LIKE to handle, you can use the regular expression pattern patch function: REGEXP_LIKE(). The following script provides you some good examples: SELECT ...
2007-04-22, 5174👍, 0💬

What Are DDL Statements
What Are DDL Statements? - Oracle DBA FAQ - Understanding SQL DDL Statements DDL (Data Definition Language) statements are statements to create and manage data objects in the database. The are 3 primary DDL statements: CREATE - Creating a new database object. ALTER - Altering the definition of an ex...
2007-04-22, 5261👍, 0💬

How To Establish Administrator Authentication to the Server
How To Establish Administrator Authentication to the Server? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 2. There are two ways to establish administrator authentication to a new database. Use a password file. Use operating system (OS) authentication. Using OS authenticati...
2007-04-22, 4972👍, 0💬

How To Create an Initialization Parameter File
How To Create an Initialization Parameter File? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 3. To run an Oracle database as an Oracle instance, you need to create an initialization parameter file, which contains a set of initialization parameters. The easiest way to creat...
2007-04-22, 5266👍, 0💬

How To Create a New Table
How To Create a New Table? - Oracle DBA FAQ - Understanding SQL DDL Statements If you want to create a new table in your own schema, you can log into the server with your account, and use the CREATE TABLE statement. The following script shows you how to create a table: >.\bin\sqlplus /nolog SQL> con...
2007-04-22, 4894👍, 0💬

How To Create a New Table by Selecting Rows from Another Table
How To Create a New Table by Selecting Rows from Another Table? - Oracle DBA FAQ - Understanding SQL DDL Statements Let's say you have a table with many data rows, now you want to create a backup copy of this table of all rows or a subset of them, you can use the CREATE TABLE...AS SELECT statement t...
2007-04-22, 5204👍, 0💬

How To Select an Oracle System ID (SID)
How To Select an Oracle System ID (SID)? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 1. If you are planning to create a new database, you need to select an Oracle System ID (SID). This ID will be used to identify the new Oracle database and its Oracle instance. SID must b...
2007-04-22, 8222👍, 0💬

How To Create an Oracle Database Manually
How To Create an Oracle Database Manually? - Oracle DBA FAQ - Creating New Database Instance Manually Based on Oracle's Administrator Guide, there are 11 steps to create a database with the CREATE DATABASE statement: Step 1: Decide on Your Instance Identifier (SID) Step 2: Establish the Database Adm...
2007-04-22, 5034👍, 0💬

How To Add a New Column to an Existing Table
How To Add a New Column to an Existing Table? - Oracle DBA FAQ - Understanding SQL DDL Statements If you have an existing table with existing data rows, and want to add a new column to that table, you can use the ALTER TABLE ... ADD statement to do this. Here is an example script: SQL> connect HR/fy...
2007-04-22, 5106👍, 0💬

How To Delete a Column in an Existing Table
How To Delete a Column in an Existing Table? - Oracle DBA FAQ - Understanding SQL DDL Statements If you have an existing column in a table and you need that column any more, you can delete it with ALTER TABLE ... DROP COLUMN statement. Here is an example SQL script: SQL> CREATE TABLE emp_dept_90 2 A...
2007-04-22, 4989👍, 0💬

What Is Open Database Communication (ODBC)
What Is Open Database Communication (ODBC)? - Oracle DBA FAQ - Oracle Basic Concepts ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle offers ODBC drivers to allow ...
2007-04-22, 5003👍, 0💬

How To Create an Oracle Database
How To Create an Oracle Database? - Oracle DBA FAQ - Creating New Database Instance Manually There are two ways to create a new database: Use the Database Configuration Assistant (DBCA) to create a database interactively. Use the CREATE DATABASE statement to create a database manually.
2007-04-22, 5076👍, 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, 4776👍, 0💬

What Is Transport Network Substrate (TNS)
What Is Transport Network Substrate (TNS)? - Oracle DBA FAQ - Oracle Basic Concepts TNS, Transport Network Substrate, is a foundation technology, built into the Oracle Net foundation layer that works with any standard network transport protocol.
2007-04-22, 5474👍, 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, 4839👍, 0💬

What Is SQL*Plus
What Is SQL*Plus? - Oracle DBA FAQ - Oracle Basic Concepts SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user inter...
2007-04-22, 5635👍, 0💬

How To Rename an Index
How To Rename an Index? - Oracle DBA FAQ - Understanding SQL DDL Statements Let's say you have an existing index, and you don't like its name anymore for some reason, you can rename it with the ALTER INDEX ... RENAME TO statement. Here is an example script on how to rename an index: CREATE TABLE stu...
2007-04-22, 4659👍, 0💬

<< < 14 15 16 17 18 19 20 21 22 23 24 > >>   Sort: Rank