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

NAME	DESCRIPTION	Created By
NEXT_DAY	NEXT_DAY returns the date of the first weekday named that is later than the date.	SUSAN HARPER
LAG	Provides access to a row at a given offset before current row	REENA KHOSLA
Explain Plan to Toad_Plan_Table	How to get an explain plan from a custom exlain table	GEOFF SWITZ
Gather Statistics on multiple tables at once	A snippet to gather stats on multiple tables (owned by your schema)	PHILIP MOORE
mr	template	MICHEL RAMIREZ
Set Date/Time Format	Set Date/Time Format	ERIC HAYCRAFT
Write a BLOB > 32K to a file	Splits BLOB's into chunks to write them to disk. Used with Apex' File Upload (HTMLDB_APPLICATION_FILES), but could easily be adapted for general use	ARNE BRUNING
Mein Snippet	das ist es	MARTIN MAYERHOFER
ALL DATE LANG	DATE WITH MANY LANGS	MOHAMED TANTAWY
date_01	records listed in reverse	DHANUNJAYA GALIPALLI

1 - 10