create function

Oracle Functions Tips

Submitted by Ben Hodson on Wed, 02/20/2008 - 17:56

This is a quick list of tips to keep in mind when working with Oracle (being a complete Oracle newb, I wish someone would have put these up on a blog instead of having to search for them).

Getting setup to do SQL commands Oracle
In the Oracle Enterprise Manager Console, you can do "straight-SQL" to Oracle. Click on the left icon "Database Applications". It will expand out to show a few icons. Click on the "SQL+ Plus Worksheet". This will open a SQL editor similar to SQL Server Enterprise Manager's (well, not that similar because Oracle's tools suck).