dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

Oracle

10 of 10     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
10 of 10     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date