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
Oracle Learning -Tips & Tricks
Describe - Oracle
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
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
In Oracle if you select specific columns along with asteric, it generates an error.
Unlock Accounts in Oracle 10g
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;
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
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)
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)
Subscribe to:
Posts (Atom)