From the course: Oracle Database 19c: Basic SQL

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Listing functions with SQL Developer

Listing functions with SQL Developer

From the course: Oracle Database 19c: Basic SQL

Start my 1-month free trial Buy for my team

Listing functions with SQL Developer

“

- [Instructor] Oracle has many tools to make your job easier. And if you want to, for example, generate a report within SQL Developer, to find a list of built in functions you can use in your queries, you can use the SQL Developer built in report functionality and create a report that sits right alongside the built in reports. I'll open SQL Developer in the default view, and in the lower left corner are the existing reports. I want to easily run a report based on a query against v dollar SQL fn underscore metadata to show the function names. I'll open a connection, paste in the query and run it with F9. The query against v dollar SQL fn underscore metadata shows the built in function metadata. The name, the minimum and maximum number of arguments, whether it's an analytic function, an aggregate function, and when I use it often for, knowing if it's a function that's offloadable on Exadata. Meaning I can take advantage of the features of Exadata Storage, to perform most of the where…

Contents