.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

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

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

How To Define a RECORD Variable to Store a Table Row
How To Define a RECORD Variable to Store a Table Row? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a table, and want to define a RECORD variable to store all the data elements of a row from that table, you can use table_name%ROWTYPE to define the RECORD variable as shown in... 2007-04-27, 5038👍, 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, 5038👍, 0💬

How a Tablespace Is Related to Data Files
How a Tablespace Is Related to Data Files? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running. 2007-05-03, 5037👍, 0💬

How To Count Duplicated Values in a Column
How To Count Duplicated Values in a Column? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you have a column with duplicated values, and you want to know what are those duplicated values are and how many duplicates are there for each of those values, you can use the GROUP BY ... HAV... 2007-04-20, 5035👍, 0💬

What Privilege Is Needed for a User to Create Tables
What Privilege Is Needed for a User to Create Tables? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges To be able to create tables in a user's own schema, the user needs to have the CREATE TABLE privilege, or the CREATE ANY TABLE privilege, which is more powerful, and allows t... 2007-05-01, 5033👍, 0💬

How To Shutdown Your 10g XE Server
How To Shutdown Your 10g XE Server? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If you want to shutdown your 10g Express Edition server, go to the Services manager in the control panel. You will a service called OracleServiceXE, which represents your 10g Express Edition se... 2007-04-24, 5029👍, 0💬

How To Build Data Dictionary View an New Database
How To Build Data Dictionary View an New Database? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 9. The Oracle Administrator Guide suggests to run two SQL scripts provided by Oracle as shown bellow: SQL> @/u01/oracle/rdbms/admin/catal og.sqlSQL> @/u01/oracle/rdbms/admin/cat.. . 2007-04-23, 5028👍, 0💬

How To Define an Anonymous Procedure without Variables
How To Define an Anonymous Procedure without Variables? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Anonymous procedure is a procedure without any name. If you don't have any variables to declare, you can define an anonymous procedure by using the BEGIN keyword directly in S... 2007-04-26, 5027👍, 0💬

What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema
What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to insert rows into tables of someone else's schema, he/she needs the INSERT ANY TABLE privilege. The following tutorial exercise gives y... 2007-05-01, 5025👍, 0💬

How To Start a New Transaction
How To Start a New Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management There is no SQL statement to explicitly start a new transaction. Oracle server implicitly starts a new transaction with the following two conditions: The first executable statement of a new user session will ... 2007-04-18, 5025👍, 0💬

How To Create a Table in a Specific Tablespace
How To Create a Table in a Specific Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files After you have created a new tablespace, you can give it to your users for them to create tables in the new tablespace. To create a table in a specific tablespace, you need to use the TABLES... 2007-05-03, 5023👍, 0💬

What Privilege Is Needed for a User to Create Indexes
What Privilege Is Needed for a User to Create Indexes? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to create indexes, he/she needs the same privilege as the creating tables. Just make sure he/she has the CREATE TABLE privilege. The following tutorial exercise g... 2007-05-01, 5022👍, 0💬

How To Change SQL*Plus System Settings
How To Change SQL*Plus System Settings? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool SQL*Plus environment is controlled a big list of SQL*Plus system settings. You can change them by using the SET command as shown in the following list: SET AUTOCOMMIT OFF - Turns off the auto... 2007-04-29, 5022👍, 0💬

How To See Free Space of Each Tablespace
How To See Free Space of Each Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files One of the important DBA tasks is to watch the storage usage of all the tablespaces to make sure there are enough free space in each tablespace for database applications to function properly. Free... 2007-05-03, 5017👍, 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, 5015👍, 0💬

How To Drop an Index
How To Drop an Index? - Oracle DBA FAQ - Understanding SQL DDL Statements If you don't need an existing index any more, you should delete it with the DROP INDEX statement. Here is an example SQL script: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHA... 2007-04-22, 5015👍, 0💬

What Is a User Role
What Is a User Role? - Oracle DBA FAQ - Oracle Basic Concepts 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-04-21, 5013👍, 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, 5010👍, 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, 5005👍, 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, 5004👍, 0💬

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

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