From the course: Oracle Database 19c: Basic SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Listing functions with SQL Developer

Listing functions with SQL Developer

From the course: Oracle Database 19c: Basic SQL

Start my 1-month free trial

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