UnZip Utilities Download

http://updates.oracle.com/unzips/unzips.html

Good free editor PSPad

http://www.pspad.com/en/

Infinity in Oracle

SQL> create table t_i (id binary_float);

Table created.

SQL> alter table t_i add (name varchar(3));

Table altered.

SQL> select * from t_i where id is nan;

no rows selected

SQL> insert into t_i values(binary_float_infinity, null);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t_i where id is infinite;

ID NAM
---------- ---
Inf

SQL> insert into t_i values(binary_float_nan, null);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t_i where id is nan;

ID NAM
---------- ---
Nan

Show hidden characters in vi

:set list

How connect to shared server as dedicated

1) tnsnames.ora connect_data server=dedicated
or
2) sqlnet.ora use_dedicated_server=on

oradim DIM-00003

One of possible reason - underscore in sid name:

C:\project\new_sid>oradim -new -SID new_sid
DIM-00003: An argument is missing for the parameter.

C:\project\new_sid>oradim -new -SID newsid
Instance created.

List of files in tar

tar -tvf file.tar