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

What Is a READ WRITE Transaction
What Is a READ WRITE Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management A READ WRITE transaction is a transaction in which the read consistency is set at the statement level. In a READ WRITE transaction, a logical snapshot of the database is created at the beginning of the exec... 2007-04-18, 5001👍, 0💬

How a Database Is Related to Tablespaces
How a Database Is Related to Tablespaces? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files A database's data is collectively stored in the datafiles that constitute each tablespace of the database. For example, the simplest Oracle database would have one tablespace and one datafile. Ano... 2007-05-03, 4998👍, 0💬

What Privilege Is Needed for a User to Create Views
What Privilege Is Needed for a User to Create Views? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges To be able to create views in a user's own schema, the user needs to have the CREATE VIEW privilege, or the CREATE ANY VIEW privilege, which is more powerful, and allows the u... 2007-05-01, 4998👍, 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, 4998👍, 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, 4997👍, 0💬

How To Use Subqueries with the IN Operator
How To Use Subqueries with the IN Operator? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements A subquery can be used with the IN operator as "expression IN (subquery)". The subquery should return a single column with one or more rows to form a list of values to be used by the IN operation... 2007-04-19, 4995👍, 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, 4994👍, 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, 4991👍, 0💬

What Is the Reports View in Oracle SQL Developer
What Is the Reports View in Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer The Reports view lets you browse database information that organized by the server as special views. Information can be browsed include: Database parameters Storage information Session informati... 2007-04-27, 4990👍, 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, 4989👍, 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, 4989👍, 0💬

How To Commit the Current Transaction
How To Commit the Current Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management If you have used some DML statements updated some data objects, and you want to have the updates to be permanently recorded in the database, you can use the COMMIT statement. It will make all the datab... 2007-04-18, 4989👍, 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, 4977👍, 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, 4977👍, 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, 4976👍, 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, 4975👍, 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, 4975👍, 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, 4975👍, 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, 4972👍, 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, 4966👍, 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, 4965👍, 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, 4961👍, 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