Oracle Learning -Tips & Tricks

Download Oracle Database 10g for 32 bit Windows

2012-10-17T01:29:00.000-07:00

I searched a lot to get oracle 10g database but I could not find any link. Oracle removed 10g download link from their available download list.
I found the following hidden link on oracle website, still providing access to oracle database 10g. Good luck for your download.

http://www.oracle.com/technetwork/developer-tools/developer-suite/downloads/101202winsoft-087370.html

Describe - Oracle

2011-03-28T11:28:00.001-07:00

You can display table, view, function, synonym, package structure by the using the describe command. Describe is SQL PLUS command.

Syntax:

Desc [table name]

Desc emp;

You can also write it as

Describe [table name]

Describe emp;

This command can also be used for view, function, synonym and packages.

Oracle Logical Operators Description/Precedence

2011-03-27T05:06:00.000-07:00

AND requires both conditions to be true.

EXAMPLE:

Select empno,ename,sal from emp where ename = ‘KHALID’ AND job

= ‘MANAGER’;

OR requires either condition to be ture.

EXAMPLE:

Select empno,ename from emp where ename = ‘KHALID’ OR job =

‘MANAGER’;

NOT negate the condition

EXAMPLE:

Select job from emp where name NOT IN (‘KHALID’,’ARSALAN’);

Select ename from emp where job NOT LIKE ‘CL%’;

PRECEDENCE RULE:

EVALUATION ORDER	OPERATOR
1	NOT
2	AND
3	OR

Selecting specific columns along with asteric from a table

2011-03-26T13:30:00.000-07:00

In Oracle if you select specific columns along with asteric, it generates an error.

This problem can resolved by querying the following way, as in many cases we need to see specific columns values along with the rest of the columns. You simply need to use an alias of the table to get the result.

Select ename, e.* from emp e;

Unlock Accounts in Oracle 10g

2011-03-19T06:52:00.000-07:00

You can lock/unlock the account by the following method.

To Lock:
ALTER USER username ACCOUNT LOCK;
Example:
Alter user john account lock;

To Unlock:
ALTER USER username ACCOUNT UNLOCK;
Example:
Alter user john account unlock;

How to view tables in Oracle

2011-02-08T10:01:00.001-08:00

In oracle, you can view tables by the following different methods/queries.

1- select * from user_objects where object_type = 'TABLE';
you need to input object type in CAPs

2-Select * from tabs;

3-Select * from User_TABLES;

4-Select * from DBA_TABLES (you must have logged in as DBA to view this)

5-Select * from all_all_tables;

6-Select * from dict (in order to get all the tables in the metadata)