Get a list of tables: select table_name from all_tables.

Get a table's structure: desc tablename.

Date format: '7-Dec-2001'.

JDBC connection URL format: jdbc:oracle:thin:@hostname:port:instance e.g. jdbc:oracle:thin:@poohpa:1521:CABOT.

-- TobyCabot - 07 Dec 2001

This topic: Tech > DatabaseTips > OracleBasics
Topic revision: r1 - 07 Dec 2001 - TobyCabot
Copyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding The Caboteria? Send feedback