Oracle main page
From WickyWiki
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
