Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

SQL

1-20 of 55     Previous     Next
Get a Table Description in Oracle's PL/SQL
by Aaron Mason
Using Oracle's PL/SQL, you can get complete table column descriptions using this command.
Determine Which Session Is Blocking All Users in Oracle
by Srinath MS
You can find out which session is causing blocking problems using this SQL command.
Run a Partial Query in TOAD
by Chithra Vijayan
You can run any portion of a SQL command in TOAD, even if it's embedded in a larger query.
Creating Tables in the Default Tablespace
by MS Sridhar
Most users typically create tables in the default tablespace. Most of them are not familiar with the actual tablespaces concept and are not aware that this is responsible for the issues they encounter when large data is pumped into said tables.
Using ANYDATA in Oracle 9i
by Shraddha Pandya
First introduced in Oracle 9i, ANYDATA is a "self-describing data instance type" which means it not only holds the value, but it also holds its own data type within each instance of it.
When to use ORDER in Sequences in PL/SQL
by Shraddha Pandya
You may need to use ORDER to force sequence numbers to be output in the order of request when you're using them for timestamping.
Quick Script Monitors Application-generated SQL
by Jason Bramsden
This script was written to monitor a program whose process life was only a few seconds. It runs forever and only outputs that SQL which is generated by the program as it's running.
Retrieve the Month's First Day for a Date
by Amit Vij
This code shows you how to retrieve the month's first day for a date.
Fetching Even and Odd Records in Oracle
by MS Sridhar
This tip will help you understand how to apply the mod function and use it to obtain even and odd records from columns in Oracle.
Dealing with Wildcard Characters in Oracle
by MS Sridhar
The ESCAPE keyword comes handy when you have a character in your data which is same as a Wildcard character.
Convert Descriptive Flex Fields to Numbers
by Kamlesh Jethwa
Often, data in Oracle applications is stored in extended columns known as Descriptive Flex Field (DFF) columns.
Handling Null Values in Oracle
by MS Sridhar
Find out how using NVL in your queries is better for displaying information and helps avoid front-end processing.
Determine the Type of Modifcation Operation on a Table
by Sachin Kainth
Find out how to use the INSERTING, DELETING and UPDATING trigger predicates to determine the type of modifcation operation that's been performed on a table.
Turning Recursive and Nested Triggers On and Off
by Sachin Kainth
This tip gives you the commands to switch recursive and nested triggers on and off.
Getting New Values Entered into a Table
by Sachin Kainth
Find out how you can use :new.<fieldname> to retrieve new values entered into a table.
Making Tables Read-only in Oracle
by MS Sridhar
In Oracle, you can only control read/write capability for an entire tablespace, not for a single table within a tablespace.
Connecting to Oracle without Configuring the tnsnames.ora File
by Bill Cressman
Learn how to avoid configuring Oracle's pesky tnsnames file when connecting to a database.
Converting Numbers into Words
by MS Sridhar
Ever written a PL/SQL block of code to convert numbers to words? This easy line of code to accomplishes the same task.
Inserting into Oracle Views and Using "Instead Of" Triggers
by Chris Farmer
Updating or inserting into a view can be difficult if your view has multiple tables. Learn how to use "instead of triggers" to make your updates easier.
Insert Large Numbers of Rows into a Database Table with PL/SQL
by Mahalakshmi Vijayaraj
1-20 of 55     Previous     Next
Sitemap