Home
Login
  • Home
  • Feature Requests
  • Snippets
  • Reports
  • Tips & Tricks
  • FAQ
  • My Requests
Snippets

What is a snippet?

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.

My Snippets
no data found
Public Snippets
NAMEDESCRIPTIONCreated By
NEXT_DAYNEXT_DAY returns the date of the first weekday named that is later than the date.SUSAN HARPER
LAGProvides access to a row at a given offset before current rowREENA KHOSLA
Explain Plan to Toad_Plan_TableHow to get an explain plan from a custom exlain tableGEOFF SWITZ
Gather Statistics on multiple tables at onceA snippet to gather stats on multiple tables (owned by your schema)PHILIP MOORE
mrtemplateMICHEL RAMIREZ
Set Date/Time FormatSet Date/Time Format ERIC HAYCRAFT
Write a BLOB > 32K to a fileSplits BLOB's into chunks to write them to disk. Used with Apex' File Upload (HTMLDB_APPLICATION_FILES), but could easily be adapted for general useARNE BRUNING
Mein Snippetdas ist esMARTIN MAYERHOFER
ALL DATE LANGDATE WITH MANY LANGSMOHAMED TANTAWY
date_01records listed in reverseDHANUNJAYA GALIPALLI
1 - 10Next
release 1.0