.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

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

How To Retrieve Data from an Explicit Cursor
How To Retrieve Data from an Explicit Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL If you have a cursor opened ready to use, you can use the FETCH ... INTO statement to retrieve data from the cursor into variables. FETCH statement will: Retrieve all the fields from the row pointed by th... 2007-04-29, 5139👍, 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, 5138👍, 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, 5138👍, 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, 5138👍, 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, 5136👍, 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, 5135👍, 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, 5134👍, 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, 5134👍, 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, 5130👍, 0💬

What Happens to the Current Transaction If a DDL Statement Is Executed
What Happens to the Current Transaction If a DDL Statement Is Executed? - Oracle DBA FAQ - Understanding SQL Transaction Management If a DDL statement is executed, the current transaction will be committed and ended. All the database changes made in the current transaction will become permanent. Thi... 2007-04-18, 5129👍, 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, 5124👍, 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, 5120👍, 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, 5119👍, 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, 5119👍, 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, 5118👍, 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, 5115👍, 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, 5112👍, 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, 5111👍, 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, 5109👍, 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, 5104👍, 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, 5104👍, 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, 5103👍, 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, 5103👍, 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