.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

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, 5118👍, 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, 5115👍, 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, 5115👍, 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, 5114👍, 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, 5114👍, 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, 5114👍, 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, 5111👍, 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, 5110👍, 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, 5108👍, 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, 5105👍, 0💬

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

How To Use SQL Statements in PL/SQL
How To Use SQL Statements in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL SQL DML (Data Manipulation Language) statements can be included in PL/SQL code blocks directly without any changes. See the script below for examples: SQL> CREATE TABLE tip (id NUMBER(5) PRIMARY KEY, 2 subject VARCHAR(80)... 2007-04-25, 5104👍, 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, 5104👍, 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, 5101👍, 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, 5101👍, 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, 5100👍, 0💬

How To Export Several Tables Together
How To Export Several Tables Together? - Oracle DBA FAQ - Loading and Exporting Data If you don't want to export the entire schema and only want to export several tables only, you can use the "expdp" command with the "TABLES" parameter as shown in the following tutorial exercise: >cd \oraclexe\app\o... 2007-05-01, 5098👍, 0💬

How To Connect a SQL*Plus Session to an Oracle Server
How To Connect a SQL*Plus Session to an Oracle Server? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool In order to connect a SQL*Plus session to an Oracle server, you need to: 1. Obtain the connection information from the Oracle server DBA. 2. Define a new "connect identifier" c... 2007-04-28, 5098👍, 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, 5095👍, 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, 5095👍, 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, 5093👍, 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, 5090👍, 0💬

How To Experiment a Data Lock
How To Experiment a Data Lock? - Oracle DBA FAQ - Understanding SQL Transaction Management If you want to have some experience with data locks, you can create two windows runing two SQL*Plus sessions. In session 1, you can run a UPDATE statements to create a data lock. Before committing session 2, s... 2007-04-17, 5089👍, 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, 5088👍, 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