.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

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

What Is an Oracle Tablespace
What Is an Oracle Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files 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. 2007-05-04, 5044👍, 0💬

What Is a Initialization Parameter File
What Is a Initialization Parameter File? - Oracle DBA FAQ - Oracle Basic Concepts An initialization parameter file is a text file that contains a list of initialization parameters. The file should be written in the client's default character set. Sample initialization parameter files are provided on... 2007-04-21, 5039👍, 0💬

How To Rollback the Current Transaction
How To Rollback the Current Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management If you have used some DML statements updated some data objects, you find a problem with those updates, and you don't want those updates to be permanently recorded in the database, you can use the ROL... 2007-04-18, 5037👍, 0💬

How To Rename a Tablespace
How To Rename a Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files You can easily rename a tablespace by using the ALTER TABLESPACE ... RENAME TO statement as shown in the example below: SQL> CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace creat... 2007-05-03, 5031👍, 0💬

How To Convert Characters to Dates
How To Convert Characters to Dates? - Oracle DBA FAQ - Understanding SQL Basics You can convert dates to characters using the TO_DATE() function as shown in the following examples: SELECT TO_DATE('07-MAY-2006', 'DD-MON-YYYY') FROM DUAL; 07-MAY-06 SELECT TO_DATE('2006/05/07 ', 'YYYY/MM/DD') FROM DUAL... 2007-04-23, 5031👍, 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, 5030👍, 0💬

How To Open and Close an Explicit Cursor
How To Open and Close an Explicit Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL An existing cursor can be opened or closed by the OPEN or CLOSE statement as shown in the following sample script: DECLARE CURSOR c_list IS SELECT * FROM countries; CURSOR t_list IS SELECT * FROM employees WH... 2007-04-29, 5029👍, 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, 5028👍, 0💬

How To Define an Anonymous Procedure with Variables
How To Define an Anonymous Procedure with Variables? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Anonymous procedure is a procedure without any name. If you have some variables to declare, you can define an anonymous procedure by using the DECLARE keyword in SQL*Plus as show... 2007-04-26, 5027👍, 0💬

How To Create a Testing Table
How To Create a Testing Table? - Oracle DBA FAQ - Understanding SQL DML Statements If you want to practice DML statements, you should create a testing table as shown in the script below: CREATE TABLE fyi_links (id NUMBER(4) PRIMARY KEY, url VARCHAR2(80) NOT NULL, notes VARCHAR2(1024), counts NUMBER,... 2007-04-22, 5026👍, 0💬

How To Install Oracle Database 10g XE
How To Install Oracle Database 10g XE? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition To install 10g universal edition, double click, OracleXEUniv.exe, the install wizard starts. It will guide you to finish the installation process. You should take notes about: The SYSTEM pas... 2007-04-24, 5025👍, 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, 5024👍, 0💬

How To Download Oracle SQL Developer
How To Download Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you want to download a copy of Oracle SQL Developer, visit http://www.oracle.com/technolo gy/software/products/sql/.If you are using Windows systems, click the "Oracle SQL Developer for Windows" link. Th... 2007-04-26, 5024👍, 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, 5020👍, 0💬

What Is a Procedure
What Is a Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A procedure is a named program unit. It consists of three parts: Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required. Execution... 2007-04-26, 5020👍, 0💬

How To Convert Numbers to Characters
How To Convert Numbers to Characters? - Oracle DBA FAQ - Understanding SQL Basics You can convert numeric values to characters by using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(4123.4570) FROM DUAL 123.457 SELECT TO_CHAR(4123.457, '$9,999,999.99') FROM DUAL $4,123.46... 2007-04-23, 5020👍, 0💬

How To Export Data with a Field Delimiter
How To Export Data with a Field Delimiter? - Oracle DBA FAQ - Loading and Exporting Data The previous exercise allows you to export data with fixed field lengths. If you want export data with variable field lengths and field delimiters, you can concatenate your fields with an expression in the SELEC... 2007-04-30, 5016👍, 0💬

How To Create a New Tablespace
How To Create a New Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you want a new dataspace, you can use the CREATE TABLESPACE ... DATAFILE statement as shown in the following script: SQL> CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace c... 2007-05-03, 5011👍, 0💬

What Are the Limitations Oracle Database 10g XE
What Are the Limitations Oracle Database 10g XE? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Oracle Database XE is free for runtime usage with the following limitations: Supports up to 4GB of user data (in addition to Oracle system data) Single instance only of Oracle Data... 2007-04-23, 5009👍, 0💬

What Are the Execution Control Statements
What Are the Execution Control Statements? - Oracle DBA FAQ - Introduction to PL/SQL PL/SQL supports three groups of execution control statements: IF Statements - Conditionally executes a block of statements. CASE Statements - Selectively executes a block of statements. LOOP Statements - Repeatedly ... 2007-04-25, 5008👍, 0💬

How To View the Data Files in the Current Database
How To View the Data Files in the Current Database? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you want to get a list of all tablespaces used in the current database instance, you can use the DBA_TABLESPACES view as shown in the following SQL script example: SQL> connect SYSTEM... 2007-05-03, 5007👍, 0💬

How Many Categories of Data Types
How Many Categories of Data Types? - Oracle DBA FAQ - Understanding SQL Basics Oracles supports the following categories of data types: Oracle Built-in Datatypes. ANSI, DB2, and SQL/DS Datatypes. User-Defined Types. Oracle-Supplied Types. 2007-04-24, 5007👍, 0💬

How To Convert Characters to Times
How To Convert Characters to Times? - Oracle DBA FAQ - Understanding SQL Basics You can convert dates to characters using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(TO_DATE('04:49:49', 'HH:MI:SS'), 'DD-MON-YYYY HH24:MI:SS') FROM DUAL; -- Default date is the first day o... 2007-04-23, 5007👍, 0💬

How To Check Your Oracle Database 10g XE Installation
How To Check Your Oracle Database 10g XE Installation? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If you want to check your fresh installation of 10g Express Edition without using any special client programs, you can use a Web browser with this address, http://localhost:8... 2007-04-24, 5006👍, 0💬

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