.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

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

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, 5062👍, 0💬

How To Omit Columns with Default Values in INSERT Statement
How To Omit Columns with Default Values in INSERT Statement? - Oracle DBA FAQ - Understanding SQL DML Statements If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you can provide a colum... 2007-04-21, 5062👍, 0💬

What Are SQL*Plus Environment Variables
What Are SQL*Plus Environment Variables? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Behaviors of SQL*Plus are also controlled a some environment variables predefined on the local operating system. Here are some commonly used SQL*Plus environment variables: ORACLE_HOME - The... 2007-04-29, 5060👍, 0💬

How To Start Oracle SQL Developer
How To Start Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer To start Oracle SQL Developer, go to \sqldeveloper and click sqldeveloper.exe. The Oracle SQL Developer window shows up. Your copy of Oracle SQL Developer is running now. There will nothing under the Connectio... 2007-04-26, 5059👍, 0💬

How To Revise and Re-Run the Last SQL Command
How To Revise and Re-Run the Last SQL Command? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If executed a long SQL statement, found a mistake in the statement, and you don't want enter that long statement again, you can use the input buffer commands to the correct last statem... 2007-04-29, 5056👍, 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, 5056👍, 0💬

How To Insert a New Row into a Table
How To Insert a New Row into a Table? - Oracle DBA FAQ - Understanding SQL DML Statements To insert a new row into a table, you should use the INSERT INTO statement with values specified for all columns as shown in the following example: INSERT INTO fyi_links VALUES (101, 'http://dev.fyicenter.com',... 2007-04-21, 5051👍, 0💬

What Happens If the Imported Table Already Exists
What Happens If the Imported Table Already Exists? - Oracle DBA FAQ - Loading and Exporting Data If the import process tries to import a table that already exists, the Data Pump Import utility will return an error and skip this table. The following exercise shows you a good example: >cd \oraclexe\ap... 2007-05-02, 5050👍, 0💬

How Much Memory Your 10g XE Server Is Using
How Much Memory Your 10g XE Server Is Using? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Your 10g XE Server is using about 180MB of memory even there is no users on the server. The server memory usage is displayed on your server home page, if you log in as SYSTEM. 2007-04-24, 5044👍, 0💬

How To Run SQL Statements through the Web Interface
How To Run SQL Statements through the Web Interface? - Oracle DBA FAQ - Managing Oracle Table Indexes If you don't like the command line interface offered by SQL*Plus, you can use the Web interface to run SQL statements. Here is how: Open your Web browser to http://localhost:8080/apex/ Log in to the... 2007-05-02, 5043👍, 0💬

How Many Data Types Are Supported
How Many Data Types Are Supported? - Oracle DBA FAQ - Introduction to PL/SQL PL/SQL supports two groups of data types: SQL Data Types - All data types used for table columns. PL/SQL Special Data Types - Like BOOLEAN or PLS_INTEGER. The script below shows some data type examples: SQL> set serveroutpu... 2007-04-25, 5043👍, 0💬

What Is a Transaction
What Is a Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management A transaction is a logical unit of work requested by a user to be applied to the database objects. Oracle server introduces the transaction concept to allow users to group one or more SQL statements into a single tran... 2007-04-18, 5043👍, 0💬

How To Create a Table Index
How To Create a Table Index? - Oracle DBA FAQ - Managing Oracle Table Indexes 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 th... 2007-05-02, 5042👍, 0💬

What Is a SELECT Query Statement
What Is a SELECT Query Statement? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements The SELECT statement is also called the query statement. It is the most frequently used SQL statement in any database application. A SELECT statement allows you to retrieve data from one or more tables, or... 2007-04-21, 5042👍, 0💬

What is Oracle Database 10g Express Edition
What is Oracle Database 10g Express Edition? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Based on Oracle Web site: Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that... 2007-04-23, 5039👍, 0💬

What Is a Server Parameter File
What Is a Server Parameter File? - Oracle DBA FAQ - Oracle Basic Concepts A server parameter file is a binary file that acts as a repository for initialization parameters. The server parameter file can reside on the machine where the Oracle database server executes. Initialization parameters stored ... 2007-04-21, 5034👍, 0💬

How To Create a New View
How To Create a New View? - Oracle DBA FAQ - Understanding SQL DDL Statements You can create a new view based on one or more existing tables by using the CREATE VIEW statement as shown in the following script: CREATE VIEW employee_department AS SELECT e.employee_id, e.first_name, e.last_name, e.emai... 2007-04-22, 5030👍, 0💬

What Are the Differences between CHAR and VARCHAR2
What Are the Differences between CHAR and VARCHAR2? - Oracle DBA FAQ - Understanding SQL Basics The main differences between CHAR and VARCHAR2 are: CHAR stores values in fixed lengths. Values are padded with space characters to match the specified length. VARCHAR2 stores values in variable lengths. ... 2007-04-24, 5026👍, 0💬

How Run SQL*Plus Commands That Are Stored in a Local File
How Run SQL*Plus Commands That Are Stored in a Local File? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you have a group of commands that you need to run them repeatedly every day, you can save those commands in a file (called SQL script file), and using the "@fileName" co... 2007-04-29, 5025👍, 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, 5025👍, 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, 5022👍, 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, 5020👍, 0💬

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, 5020👍, 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, 5017👍, 0💬

<< < … 12 13 14 15 16 17 18 19 20 21 22 … > >>   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