Oracle main page

Admin

• Oracle 9+ Import
• Oracle 10+ Import and Export
• Oracle 10+ Recyclebin
• Determine Oracle version
• Shrink undo tablespace
• Query tablespace size and usage
• Recreate tablespace and user
• Resize datafile
• Resize System Global Area (SGA)
• Create and use database link
• Oracle trace logging

SQL

• Oracle Recordcount of all user tables
• Oracle Query hierarchical relations with "connect by"
• Oracle Disable all constraints with a subscript
• Oracle Get DDL for an object
• Oracle Rename a table
• Oracle Cast VARRAY type to table type
• Oracle Drop table with its constraints
• Oracle Fuzzy Text Matching
• Access CSV file as a table
• Merge update table with data from other table
• Oracle Pivot and Merge

PL/SQL

• Write a file to an Oracle-directory
• Aggregate text values
• Initialize sequence value
• Creating a package
• Loop over records
• Oracle protecting PL/SQL sourcecode
• Schema wide text search

Locator and Spatial

• Oracle Using SDO_AGGR_UNION
• Oracle Centroid of a specific geometry
• Oracle Create spatial index
• Oracle Change geometry elements
• Oracle Validate and rectify geometry
• Oracle From x,y and rotation to a line
• Oracle Get values from oracle object types
• Oracle Selecting geometries inside polygon
• Oracle Using SDO_JOIN
• Oracle Spatial Topological Relations
• Extensive spatial functions package
• Geometry to wkt curve polygon
• Spatial replacement functions
• Spatial multipolygon to polygon