Home > Data Miner 4.0 > Oracle Data Mining Applicat... > Snippets
SQL Developer provides Snippets that help you write PL/SQL programs. Snippets are code fragments, such as SQL functions, Optimizer hints, and miscellaneous PL/SQL programming techniques. Some snippets are just syntax, and others are examples. You can insert and edit snippets when you are using the SQL Worksheet or creating or editing a PL/SQL function or procedure. To display snippets, from the View menu, select Snippets. In the snippets window (on the right side), use the drop-down to select a group (such as Aggregate Functions or Predictive Analytics). In most cases, the fragments in each group do not represent all available objects in that logical grouping, or all formats and options of each fragment shown.
To insert a snippet into your code in a SQL Worksheet or in a PL/SQL function or procedure, drag the snippet from the snippets window and drop it into the desired place in your code; then edit the syntax so that the SQL function is valid in the current context. To see a brief description of a SQL function in a tool tip, hold the pointer over the function name.
The Predictive Analytics snippets provide examples of programs using the DBMS_PREDICTIVE_ANALYTICS functions.