Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips

Oracle - Page 3

41-60 of 173     Previous     Next
Using the IF Condition in SQL with an Oracle Database
by Sridhar MS
Compare Oracle and SQL Server Dates
by Andy Clark
GetSqlPlusPath - Get the path of the Oracle's SqlPlus.exe utility
by Marco Bellinaso
Get the path of the Oracle's SqlPlus.exe utility
A Script That Lists All Tables and Their Column Names With Data Types
by Jatin Kumar
This script creates a report of all user owned tables and their columns with data types and nullability information. ...
Who Is Using the Oracle Database?
by Shiv Kumar
Renaming an Oracle Table
by Jiwan Kishore
Create a synonym to the table with a new name. A public synonym is accessible by all schemas in the database, not just the user who created the synonym.
Setting the SQL Plus Environment With login.SQL File
by Shiv Gupta
The environment of a SQL plus session, like linesize, pagesize, etc., can be permanently set according to one's own needs with the help of login.sql file. The settings can be set by a SET ...
Determining the Size of an Oracle Database
by Shiv Gupta
The size of the database is the total size of the datafiles that make up the tablespaces of the database. These details are found in the dba_extents view. Type the following lines at the SQL-PLUS ...
Examine the Number of Extents in a Table
by Jose Antonio
The amount of time it takes to retrieve data blocks is proportionate to the number of extents in the table. Ideally, a table should have one to three extents. Run this script from sqlplus to get ...
Storing Character Large Objects in an Oracle Table
by Oleg Kozlov
Even the latest versions of Oracle
How To Improve Your Tablespaces
by Carlos Alvarez
The following technique will allow you to free your tablespaces from Oracle
Use Of 'Connect By' clause for Hierarchal Query
by Trupti Rajparia
The Connect By clause is useful for tables which have 2 or more columns with parent-child relationships. While displaying rows, we can use 'LEVEL' pseudo column to indent the results as hierarchy.
Code to Send E-Mails from an Oracle Stored Procedure
by Jose Antonio
The following code (based on the UTL_SMTP package supplied in Oracle8i V8.1.6, ...
Use Decode Function for Oracle Queries
by Trupti Rajparia
Decode is a very useful and handy function for Oracle queries. ...
Showing Rows of a Table in Columns Format
by Jatin Shah
Sometimes in our database structures we've got to store information in such a ...
Using ROWNUM Pseudocolumn in Oracle
by Trupti Rajparia
When querying in Oracle, use ROWNUM pseudocolumn to limit the number of returned rows. Pseudocolumns behave like table columns but are not actually stored in tables. (Other pseudocolumns are RowId, ...
SubQueries in the FROM Clause of SELECT
by Trupti Rajparia
When a SubQuery is used in a FROM clause instead of a Table name, Oracle ...
Optimize Oracle's SQL Statement Cache
by Andrew Holliday
When Oracle receives a SQL statement to execute, it first looks to see ...
Determining Your Session IDs for SQL Server and Oracle
by Andrew Holliday
If you work with SQL Server or Oracle you at some point probably will need ...
Roles Are Disabled at Package Compilation Time
by Trupti Rajparia
When granting permissions through roles, it is important to know that ...
41-60 of 173     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date