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

Oracle - Page 2

21-40 of 170     Previous     Next
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.
Presenting Dates in Varying Formats
by Sridhar MS
Dates are generally a requirement for every application. However, including dates for users across the globe can be tedious, because different people use different formats to read the date.
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.
Use Oracle and Triggers to Secure Table Data
by Sridhar MS
Ever deleted some tables accidently and had to waste your time doing them all over again? Oracle, in conjunciton with Triggers, provides an easy solution to this problem.
Use Oracle Obfuscation to Encrypt Data Securely
by Sushil Srivastava
Learn how to encrypt data—like passwords and other confidential information—using Oracle Obfuscation techniques.
Read an Image from a Database and Show it in a Browser
by David Elayaraja
This script reads the image from the databse and uses JDBC and stream to write it into a browser.
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.
Report the Name of the Current Database Instance
by Shushil Srivastava
Use this small code snippet to query the GLOBAL_NAMES view in Oracle.
Automatically Create All Missing Synonyms in an Oracle Database
by Shushil Srivastava
This script saves you trouble by creating the appropriate synonyms for your schema objects automatically.
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
21-40 of 170     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date