.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

<< < … 3 4 5 6 7 8 9 10 11 12 13 … > >>   Sort: Date

What Are DDL Statements
What Are DDL Statements? - Oracle DBA FAQ - Understanding SQL DDL Statements DDL (Data Definition Language) statements are statements to create and manage data objects in the database. The are 3 primary DDL statements: CREATE - Creating a new database object. ALTER - Altering the definition of an ex... 2007-04-22, 5534👍, 0💬

How To Do Clean Up If CREATE DATABASE Failed
How To Do Clean Up If CREATE DATABASE Failed? - Oracle DBA FAQ - Creating New Database Instance Manually To better organize data files, you should create a dedicated directory for each Oracle database. This can be done by using Windows file explorer to create the \oraclexe\oradata\fyi\ directory. Tr... 2007-04-23, 5533👍, 0💬

How To Create a Procedure Interactively
How To Create a Procedure Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you want to create a stored procedure interactively, you can use the following steps: Open you connection name, like Local_XE. Right-click Procedures. Select Create PROCEDURE. The Create Procedure win... 2007-04-28, 5531👍, 0💬

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

How To Run SQL Statements with Oracle SQL Developer
How To Run SQL Statements with Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Once a connection is established with an Oracle server, you can enter any SQL statements in the SQL Statement area. Try yourself with the following steps: Go to the SQL Statement area Enter S... 2007-04-27, 5525👍, 0💬

How To Create a New Table by Selecting Rows from Another Table
How To Create a New Table by Selecting Rows from Another Table? - Oracle DBA FAQ - Understanding SQL DDL Statements Let's say you have a table with many data rows, now you want to create a backup copy of this table of all rows or a subset of them, you can use the CREATE TABLE...AS SELECT statement t... 2007-04-22, 5517👍, 0💬

What Are the System Predefined User Roles
What Are the System Predefined User Roles? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges Oracle 10g XE comes with 3 predefined roles: CONNECT - Enables a user to connect to the database. Grant this role to any user or application that needs database access. RESOURCE - Enabl... 2007-05-02, 5516👍, 0💬

How To Run the Anonymous Block Again
How To Run the Anonymous Block Again? - Oracle DBA FAQ - Introduction to PL/SQL If you have an anonymous block defined in your session, you can run it any time by using the "/" command as shown in the following script: SQL> set serveroutput on; SQL> begin 2 dbms_output.put_line('This is a PL/SQL FAQ... 2007-04-25, 5515👍, 0💬

How To List All Tables in Your Schema
How To List All Tables in Your Schema? - Oracle DBA FAQ - Managing Oracle Database Tables If you log in with your Oracle account, and you want to get a list of all tables in your schema, you can get it through the USER_TABLES view with a SELECT statement, as shown in the following SQL script: SQL> c... 2007-05-04, 5510👍, 0💬

What Are the General Rules on Data Consistency
What Are the General Rules on Data Consistency? - Oracle DBA FAQ - Understanding SQL Transaction Management All SQL statements always work with a snapshot of the database to provide data consistency. For READ WRITE transactions, the snapshot is taken when each statement starts. For READ ONLY transac... 2007-04-17, 5508👍, 0💬

What Happens If Variable Names Collide with Table/Column Names
What Happens If Variable Names Collide with Table/Column Names? - Oracle DBA FAQ - Working with Database Objects in PL/SQL When a variable name collides with a column name, PL/SQL will use it as the variable if it is used where variable is allowed; It will be used as the column, if it is used where ... 2007-04-28, 5502👍, 0💬

How To Unlock the Sample User Account
How To Unlock the Sample User Account? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Your 10g XE server comes with a sample database user account called HR. But this account is locked. You must unlock it before you can use it: Log into the server home page as SYSTEM. Click t... 2007-04-24, 5500👍, 0💬

Can the Query Output Be Sorted by Multiple Columns
Can the Query Output Be Sorted by Multiple Columns? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns employees' salaries sorted by department and salary value: SQL> SELEC... 2007-04-20, 5498👍, 0💬

How To Delete an Existing Row from a Table
How To Delete an Existing Row from a Table? - Oracle DBA FAQ - Understanding SQL DML Statements If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements: INSERT INTO fyi_links (url, id) VAL... 2007-04-21, 5496👍, 0💬

How To Revoke CREATE SESSION Privilege from a User
How To Revoke CREATE SESSION Privilege from a User? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you take away the CREATE SESSION privilege from a user, you can use the REVOKE command as shown in the following example script: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fy... 2007-05-01, 5491👍, 0💬

What Happens If You Use a Wrong Connect Identifier
What Happens If You Use a Wrong Connect Identifier? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Of course, you will get an error, if you use a wrong connect identifier. Here is an example of how SQL*Plus react to a wrong connect identifier: SQL> CONNECT fyi/retneciyf@WRONG; ... 2007-04-28, 5491👍, 0💬

How To Create an Initialization Parameter File
How To Create an Initialization Parameter File? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 3. To run an Oracle database as an Oracle instance, you need to create an initialization parameter file, which contains a set of initialization parameters. The easiest way to creat... 2007-04-22, 5489👍, 0💬

What Are the Restrictions in a READ ONLY Transaction
What Are the Restrictions in a READ ONLY Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management There are lots of restrictions in a READ ONLY transaction: You can not switch to READ WRITE mode. You can not run any INSERT, UPDATE, DELETE statements. You can run SELECT query statemen... 2007-04-17, 5489👍, 0💬

How To Get a List of All Background Sessions in the Database
How To Get a List of All Background Sessions in the Database? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you don't like to use a SELECT statement to get a list of all background sessions in the current database, you can use the Reports view to do this as shown in the following tutori... 2007-04-27, 5487👍, 0💬

How To Delete a Column in an Existing Table
How To Delete a Column in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables 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 AS... 2007-05-03, 5486👍, 0💬

How To Rename a Column in an Existing Table
How To Rename a Column in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables Let's say you have an existing with an existing column, but you don't like the name of that column, can you rename that column name? The answer is yes. You can use the ALTER TABLE ... RENAME COLUMN statem... 2007-05-03, 5486👍, 0💬

How To Assign Values to Data Fields in RECORD Variables
How To Assign Values to Data Fields in RECORD Variables? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If a variable is a RECORD variable, you can assign values to its data fields by using fields names prefixed with variable name as "variable.field_name". Here is a sample script assigni... 2007-04-27, 5473👍, 0💬

How To Create a Table Interactively
How To Create a Table Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you don't want to use SQL statements to create a new table, you use SQL Developer to create one interactively. Follow the steps below to create a new table called: TIP Right-click on the Tables in the obj... 2007-04-27, 5471👍, 0💬

How To Loop through a Cursor Variable
How To Loop through a Cursor Variable? - Oracle DBA FAQ - Working with Cursors in PL/SQL Once a cursor variable is opened with a query statement, it will have the same attributes as a normal cursor and it can be used in the same way a normal cursor too. The following sample script shows you how to l... 2007-04-28, 5467👍, 0💬

<< < … 3 4 5 6 7 8 9 10 11 12 13 … > >>   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