.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

<< < … 9 10 11 12 13 14 15 16 17 18 19 … > >>   Sort: Date

What Is an Oracle Data File
What Is an Oracle Data File? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files An Oracle data file is a big unit of physical storage in the OS file system. One or many Oracle data files are organized together to provide physical storage to a single Oracle tablespace. 2007-05-04, 5159👍, 0💬

What Is a User Role
What Is a User Role? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges A user role is a group of privileges. Privileges are assigned to users through user roles. You create new roles, grant privileges to the roles, and then grant roles to users. 2007-05-02, 5159👍, 0💬

How To Install Oracle SQL Developer
How To Install Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Once you have sqldeveloper-v1.0.0.zip downloaded, extract the zip file into the root directory: \. When the extraction is done, the installation is completed. Your copy of Oracle SQL Developer is installed i... 2007-04-26, 5159👍, 0💬

What Is a READ ONLY Transaction
What Is a READ ONLY Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management A READ ONLY transaction is a transaction in which the read consistency is set at the transaction level. In a READ ONLY transaction, a logical snapshot of the database is created at the beginning of the trans... 2007-04-17, 5159👍, 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, 5155👍, 0💬

How To Use Subqueries with the EXISTS Operator
How To Use Subqueries with the EXISTS Operator? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements A subquery can be used with the EXISTS operator as "EXISTS (subquery)", which returns true if the subquery returns one or more rows. The following statement is a good example of "EXISTS (subq... 2007-04-19, 5154👍, 0💬

How To Run PL/SQL Statements in SQL*Plus
How To Run PL/SQL Statements in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want to run a single PL/SQL statement in SQL*Plus, you need to use the EXECUTE command as shown in the following tutorial example: SQL> SET SERVEROUTPUT ON SQL> EXECUTE DBMS_OUTPUT.P... 2007-04-29, 5153👍, 0💬

How To Grant CREATE SESSION Privilege to a User
How To Grant CREATE SESSION Privilege to a User? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want give a user the CREATE SESSION privilege, you can use the GRANT command. The following tutorial exercise shows you how to grant DEV the privilege to connect to the ser... 2007-05-02, 5152👍, 0💬

How To Start Instance with a Minimal Initialization Parameter File
How To Start Instance with a Minimal Initialization Parameter File? - Oracle DBA FAQ - Creating New Database Instance Manually The sample initialization parameter file provided by Oracle seems to be not working. But we can try to start the new instance with a minimal initialization parameter file (P... 2007-04-23, 5152👍, 0💬

How To Shutdown Your 10g XE Server from Command Line
How To Shutdown Your 10g XE Server from Command Line? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition You can shutdown your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StopDB.bat. The ... 2007-04-24, 5150👍, 0💬

How To Define a Variable to Match a Table Column Data Type
How To Define a Variable to Match a Table Column Data Type? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a table, and want to define some variables to have exactly the same data types as some columns in that table, you can use table_name.column_name%TYPE as data types to de... 2007-04-26, 5149👍, 0💬

How Many Anonymous Blocks Can Be Defined
How Many Anonymous Blocks Can Be Defined? - Oracle DBA FAQ - Introduction to PL/SQL An anonymous block is stored in the user's current session without any name. So you can only define one anonymous block at any time. If you define another anonymous block, the new block will replace the previously de... 2007-04-25, 5147👍, 0💬

How To Run CREATE DATABASE Statement
How To Run CREATE DATABASE Statement? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 7. Oracle Administrator Guide provided a sample CREATE DATABASE statement. But it is a long statement. You can modify and same it in a file, $ORACLE_HOME/configscripts/cre ate_database_fyi.sq... 2007-04-23, 5146👍, 0💬

How To Start Your 10g XE Server from Command Line
How To Start Your 10g XE Server from Command Line? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition You can start your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StartDB.bat. The batch... 2007-04-24, 5144👍, 0💬

How To Load Data through External Tables
How To Load Data through External Tables? - Oracle DBA FAQ - Loading and Exporting Data If you have data stored in external files, you can load it to database through an external table by the steps below: Create an external table with columns matching data fields in the external file. Create a regul... 2007-04-30, 5143👍, 0💬

What Happens to the Current Transaction If the Session Is Ended
What Happens to the Current Transaction If the Session Is Ended? - Oracle DBA FAQ - Understanding SQL Transaction Management If a session is ended, the current transaction in that session will be committed and ended. All the database changes made in the current transaction will become permanent. Thi... 2007-04-18, 5141👍, 0💬

What Happens If You Set the SGA Too Low
What Happens If You Set the SGA Too Low? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Let's you made a mistake and changed to SGA to 16MB from the SYSTEM admin home page. When you run the batch file StartDB.bat, it will return a message saying server stated. However, if you... 2007-04-24, 5140👍, 0💬

How Remove Data Files befor opening a Database
How Remove Data Files befor opening a Database? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files Let's say you have a corrupted data file or lost a data file. Oracle can mount the database. But it will not open the database. What you can do is to set the bad data file as offline befor o... 2007-05-02, 5138👍, 0💬

What Are the Types PL/SQL Code Blocks
What Are the Types PL/SQL Code Blocks? - Oracle DBA FAQ - Introduction to PL/SQL There are 3 types of PL/SQL code blocks: Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers. Stored Program Unit - A block of codes with a name.... 2007-04-25, 5137👍, 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 - Managing Oracle User Accounts, Schema and Privileges 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 ... 2007-05-02, 5136👍, 0💬

How To Invoke the Original Export Import Utilities
How To Invoke the Original Export Import Utilities? - Oracle DBA FAQ - Loading and Exporting Data If you really want to run the original export import utilities, you can still go to "bin" directory of the Oracle server path and run the "exp" or "imp" command. The tutorial exercise below tells you ho... 2007-05-02, 5135👍, 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, 5134👍, 0💬

How To Add a New Column to an Existing Table with a Default Value
How To Add a New Column to an Existing Table with a Default Value? - Oracle DBA FAQ - Managing Oracle Database Tables If you want to add a new column to an existing table, and insert a default value in this column on all existing data rows, you can use the ALTER TABLE ... ADD statement with the DEFA... 2007-05-03, 5133👍, 0💬

How To Run SQL Commands in SQL*Plus
How To Run SQL Commands in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want to run a SQL command in SQL*Plus, you need to enter the SQL command in one or more lines and terminated with (;). The tutorial exercise below shows a good example: SQL> SELECT 'Welco... 2007-04-29, 5132👍, 0💬

<< < … 9 10 11 12 13 14 15 16 17 18 19 … > >>   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