.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

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

What Is SQL*Plus
What Is SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iS... 2007-04-28, 5522👍, 0💬

How To Invoke the Data Pump Import Utitlity
How To Invoke the Data Pump Import Utitlity? - Oracle DBA FAQ - Loading and Exporting Data The Data Pump Import utility is distributed as executable file called "impdp.exe". To invoke this utility, you should go to the "bin" directory of your Oracle server installation and run the "impdp" command. H... 2007-05-01, 5521👍, 0💬

How Many Scalar Data Types Are Supported in PL/SQL
How Many Scalar Data Types Are Supported in PL/SQL? - Oracle DBA FAQ - Understanding PL/SQL Language Basics PL/SQL supports many scalar data types divided into 4 groups: Numeric Types: BINARY_DOUBLE, BINARY_FLOAT, BINARY_INTEGER, DEC, DECIMAL, DOUBLE PRECISION, FLOAT, INT, INTEGER, NATURAL, NATURALN... 2007-04-30, 5513👍, 0💬

Can SELECT Statements Be Used on Views
Can SELECT Statements Be Used on Views? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements Select (query) statements can used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view: SQL> CREATE VIEW managed_de... 2007-04-20, 5512👍, 0💬

What Is a Function
What Is a Function? - Oracle DBA FAQ - Understanding PL/SQL Language Basics A function is a named program unit. It consists of three parts: Declaration Part - Defining the function name, calling parameters, return value type, local variables and local procedures. Declaration part is required. Execut... 2007-04-30, 5510👍, 0💬

How To Bring a Tablespace Online
How To Bring a Tablespace Online? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you have brought a tablespace offline, now you want to make it available to users again, you can use the ALTER TABLESPACE ... ONLINE statement as shown in the following script: SQL> connect HR/fyicente... 2007-05-03, 5509👍, 0💬

What Is NULL
What Is NULL? - Oracle DBA FAQ - Understanding SQL Basics NULL is a special value representing "no value" in all data types. NULL can be used on in operations like other values. But most opertations has special rules when NULL is involved. The tutorial exercise below shows you some examples: SET NUL... 2007-04-23, 5509👍, 0💬

How To Use NULL as Conditions
How To Use NULL as Conditions? - Oracle DBA FAQ - Understanding SQL Basics If you want to compare values against NULL as conditions, you should use the "IS NULL" or "IS NOT NULL" operator. Do not use "=" or "&lt;>" against NULL. The sample script below shows you some good examples: SELECT 'A' IS... 2007-04-23, 5496👍, 0💬

How To Get Execution Path Reports on Query Statements
How To Get Execution Path Reports on Query Statements? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If your user account has autotrace configured by the DBA, you can use the "SET AUTOTRACE ON EXPLAIN" command to turn on execution path reports on query statements. The tutorial... 2007-04-30, 5495👍, 0💬

How To Create Your Own Reports in SQL Developer
How To Create Your Own Reports in SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Oracle SQL Developer also lets you create your own reports. See the following steps on how to do this: Click menu View. Selects Reports from the menu. Open Reports. Right-click on User Defined Re... 2007-04-27, 5494👍, 0💬

How To Pass Parameters to Procedures
How To Pass Parameters to Procedures? - Oracle DBA FAQ - Introduction to PL/SQL Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this: SQ... 2007-04-26, 5490👍, 0💬

How To Delete All Rows a Table
How To Delete All Rows a Table? - Oracle DBA FAQ - Understanding SQL DML Statements If you want to delete all rows from a table, you have two options: Use the DELETE statement with no WHERE clause. Use the TRUNCATE TABLE statement. The TRUNCATE statement is more efficient the DELETE statement. The t... 2007-04-21, 5488👍, 0💬

What Is a Dead Lock
What Is a Dead Lock? - Oracle DBA FAQ - Understanding SQL Transaction Management A dead lock is phenomenon happens between two transactions with each of them holding a lock that blocks the other transaction as shown in the following diagram: (transaction 1) (transaction 2) update row X to create loc... 2007-04-17, 5483👍, 0💬

How To Write a Left Outer Join with the WHERE Clause
How To Write a Left Outer Join with the WHERE Clause? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you don't want to use the LEFT OUTER JOIN ... ON clause to write a left outer join, you can use a special criteria in the WHERE clause as "left_table.column = right_table.column(+)".... 2007-04-19, 5482👍, 0💬

How To Rebuild an Index
How To Rebuild an Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you want to rebuild an index, you can use the "ALTER INDEX ... REBUILD statement as shown in the following SQL script: SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'EMPLOYEES'; INDEX_NAME T... 2007-04-27, 5480👍, 0💬

How To Convert Times to Characters
How To Convert Times to Characters? - 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(SYSDATE, 'HH:MI:SS') FROM DUAL; 04:49:49 SELECT TO_CHAR(SYSDATE, 'HH24:MI:SS.FF') FROM DUAL; -- Error: S... 2007-04-23, 5479👍, 0💬

How To Load Data from External Tables to Regular Tables
How To Load Data from External Tables to Regular Tables? - Oracle DBA FAQ - Loading and Exporting Data Once you have your data entered in a text file, and an external table defined to this text file, you can easily load data from this text file to a regular table. The following tutorial exercise sho... 2007-05-01, 5478👍, 0💬

How To Use "OUT" Parameter Properly
How To Use "OUT" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Here are the rules about OUT parameters: A formal OUT parameter acts like an un-initialized variable. It must be assigned with new values before the end of the procedure or function. An actual O... 2007-04-21, 5478👍, 0💬

How To Update a Table Row with a Record
How To Update a Table Row with a Record? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a RECORD variable with data fields matching a table structure, you can update a row in this table with this RECORD variable using the UPDATE ... SET ROW statement as shown in the sample sc... 2007-04-26, 5473👍, 0💬

How To View the Dropped Tables in Your Recycle Bin
How To View the Dropped Tables in Your Recycle Bin? - Oracle DBA FAQ - Managing Oracle Database Tables You can look what's in your recycle bin through the predefined view called RECYCLEBIN. You can use the SELECT statement to list the dropped tables as shown in the following script: SQL> connect HR/... 2007-05-04, 5471👍, 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, 5468👍, 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, 5462👍, 0💬

Where Is the Export Dump File Located
Where Is the Export Dump File Located? - Oracle DBA FAQ - Loading and Exporting Data If you are not specifying the dump directory and file name, the dump file will be stored in the default dump directory with the default file name. The tutorial exercise below tells you find what is your default dump... 2007-05-01, 5459👍, 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, 5454👍, 0💬

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