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

1-20 of 173     Previous     Next
Use SUBSTR to Remove the Last Character from any String in Oracle SQL
by Ben Brumm
Language: SQL, Expertise: Beginner — This code snippet is great for removing trailing slashes or other characters from the end of a string.
How to Convert to a Specific Data Type Using CAST in Oracle SQL
by Ben Brumm
Language: SQL, Expertise: Intermediate — If you need to convert to a specific data type (and length or precision), you can use the CAST function.
Add Months to a Date in Oracle SQL
by Ben Brumm
Language: SQL, Expertise: Beginner — Learn to easily add a number of months to a date in Oracle SQL with the ADD_MONTHS function.
Remove a Constraint from a Table in Oracle SQL
by Ben Brumm
Language: SQL, Expertise: Beginner — Learn how to remove constraints that have been set up to enforce business rules on a database.
Find the Source Code of a Function or Procedure in Oracle SQL
by Ben Brumm
Language: SQL, Expertise: Beginner — If you need to find the source code for a function or procedure in the database, it's easy to do in Oracle.
Add Multiple Columns to a Table in a Single Statement in Oracle SQL
by Ben Brumm
Language: SQL, Expertise: Beginner
Get a List of all Tables In Oracle SQL
by Ben Brumm
How to Undo Dropping a Table in Oracle SQL
by Ben Brumm
Language: SQL||Expertise: Beginner
Change the Output Format of a Date with TO_DATE
by Ben Brumm
Language: SQL||Expertise: Beginner
Convert Oracle Queries into Microsoft SQL Format
by Andrew Kuprianov
Language: SQL||Expertise: Intermediate
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.
How to Store Oracle 10g Log Files in XML
by Srinath MS
Oracle 10g supports several ways to store log files, including XML.
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 the GRANT Command
by Alexander Ocher
The SQL GRANT command is used to grant access privileges to database objects and role authorizations.
Trigger Efficiency in Oracle
by Alexander Ocher
It turns out that the latest documentation for Oracle 10g and 11g is incorrect and the documentation for Oracle 9i and previous releases is correct: AFTER row triggers are more efficient than BEFORE row triggers.
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.
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.
Predicate Pushing
by Shraddha Pandya
Oracle supports the pushing of predicates into a given view.
How to Use Oracle Java XQuery API
by Leonard Anghel
This code illustrates the main steps involved in using the Oracle Java XQuery API (OJXQI).
1-20 of 173     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date