Here's a list of common TCP ports. You can find a more complete list here: http://www.gasmi.net/docs/tcp.html . Port Number Service Description 21 FTP File Transfer Protocol 22 SSH Secure Shell 23 Telnet Telnet remote login 25 SMTP Simple Mail Transfer Protocol 70 gopher Gopher 79 finger Finger 80 HTTP Hyper Text Transfer Protocol (WWW) 88 Kerberos Kerberos authentication 94 tivoli Tivoli Object Dispatcher 110 pop3 Post Office Protocol Version 3 123 ntp Network Time Protocol 137 netbios NetBIOS Name Service 138 netbios NetBIOS Datagram 139 netbios NetBIOS Session 143 imap Internet Message Access Protocol 161 snmp Simple Network Management Protocol 162 snmptrap SNMP trap 194 irc Internet Relay Chat Protocol 389 ldap Lightweight Directory Access Protocol 443 https Secure HTTP 445 SMB MS Server Message...

SQL> desc user_role_privs; Name ... Further reference: Oracle Database Security Guide (11g Release 2)

Use this to connect to oracle RAC (Real Application Cluster): jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on) ... From Oracle Database JDBC Developer's Guide : Specifier Supported Drivers Example Oracle Net connection descriptor Thin, OCI Thin, using an address list: url="jdbc:oracle:thin:@(DESCRIPTION= (LOAD_BALANCE=on) (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=service_name)))" OCI, using a cluster: "jdbc:oracle:oci:@(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=cluster_alias) (PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=service_name)))" Thin-style service name Thin "jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename" LDAP syntax Thin "jdbc:oracle:thin:@ldap://ldap.example.com:7777/sales,cn=OracleContext,dc=com" Bequeath connection OCI Empty. That is, nothing after @ "jdbc:oracle:oci:scott/tiger/@" TNSNames alias Thin, OCI OracleDataSource ods = new OracleDataSource(); ods.setTNSEntryName("MyTNSAlias");

From Oracle doc: DBA_FREE_SPACE describes the free extents in all tablespaces in the database. Note that if a datafile (or entire tablespace) is offline in a locally managed tablespace, you will not see any extent information. If an object has extents in an online file of the tablespace, you will see extent information about the offline datafile. However, if the object is entirely in the offline file, a query of this view will not return any records. SQL> select tablespace_name, count(*) free_extends...

This comes from the Oracle Database Security Guide. View Description DBA_COL_PRIVS ALL_COL_PRIVS USER_COL_PRIVS DBA view describes all column object grants in the database. ALL view describes all column object grants for which the current user or PUBLIC is the object owner, grantor, or grantee. USER view describes column object grants for which the current user is the object owner, grantor, or grantee. ALL_COL_PRIVS_MADE USER_COL_PRIVS_MADE ALL view lists column object grants for which the current user is object owner or grantor. USER view describes column object grants for which the current user is the grantor. ALL_COL_PRIVS_RECD USER_COL_PRIVS_RECD ALL view describes column object grants for which the current user or PUBLIC is the grantee. USER view describes column object grants for which the current user is the...

The COALESCE function returns the first non-null expression in the expression list. It returns null when all expressions evaluate to null . This example is from Oracle documentation : SELECT product_id, list_price, min_price, COALESCE... Result: PRODUCT_ID LIST_PRICE MIN_PRICE Sale ...

Oracle provides two versions of SQLPlus: a command line version ( sqlplus.exe ) and a windows version ( sqlplusw.exe ). The windows version is rather primitive (ever used Windows 3.1?), but it moved many commands/options to the menus. So it may still be easier to get started with it then the command line version. However, you may be better off with the command line version after you get somewhat familiar with SQLPlus. In SQL*Plus you can enter: SQL*Plus commands. For a list of commands enter help index at the SQL prompt SQL commands - SQL statements sent to the database. These statements are terminated by semicolon unless you change it PL/SQL blocks - Blocks of PL/SQL code. When you enter a SQL command or PL/SQL...

select * from dba_db_links; select name from v$...

The Oracle NVL function lets you use an alternative value when a null is encountered. -- list name with email or 'N/A' if not availa...

Suppose you have a file with these lines: -- contents of update_contact.sql update co... You can execute this script from the SQL prompt by entering: @update_contact.sql And it would execute fine. Now you get the contents of the script into the SQL buffer by: GET update_contact.sql and use the / command to execute the buffer, you get ORA-00911 invalid character error for the semicolon at the first line. Confusing, right? It turned out that the semicolon is used by SQL*Plus to signify the end of a SQL command. When you enter SQL commands into SQL*Plus, it strips the trailing semicolon before sending the SQL command to the database. But when you import the contents of a file with the GET command, the semicolon is...