John Topley's Knowledgebase

Oracle Entries

Saturday, 16 October 2004

SQL Statement To List Schemas

This Oracle SQL statement will display a list of schemas within the database.

Friday, 10 September 2004

SQL Statement To List Tables Within Current Schema

This Oracle SQL statement will display the names of all the tables within the current user's schema.

Tuesday, 10 August 2004

SQL Statement To Change A User's Password

This Oracle SQL statement will change the specified user's password.

Sunday, 14 September 2003

SQL Statement To Return The Top n Rows

This Oracle SQL statement will return the top n rows in a table named t, ordered by a column named c.

Sunday, 17 August 2003

Oracle Containers for Java (OC4J) Command-Line Reference

An abridged command-line reference for OC4J.

top