For a nice overview of SQL and ANSI, see Intro To SQL.
As the link above says, vendors want to differentiate themselves so they add features unique to themselves. In this case, it is the addition of SQL-callable functions.
I don't know of a source that says for function "x" in SQL Server call function "y" in Oracle. The best site I've seen that does that is now very old (Oracle v7.3) but it might be a good place to start. Also, all of Oracle's documentation is free on an Oracle web site. You may have to sign up for a free membership.
If you have a specific question about using one of the functions or about using PL/SQL, be sure to send it this way!
Dig Deeper on Oracle and SQL
Related Q&A from Lewis Cunningham
I need a step-by-step procedure for importing text to an Oracle database using a stored procedure. Continue Reading
How can I tell if a column is a NUMBER or VARCHAR in PL/SQL? Is there a function to do this? Continue Reading
I need to somehow log the execution time for two procedures every time they are called and save that data (in a table?). Do you know of a way to ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.