Basic Commands for Oracle 10g

BIT0119-Asif at 17h38
11
Jul
2010
Basic Commands for Oracle 10g

1) Select db: desc dba_tablename;

2) Connect: conn sys/'password' as sysdba;

3) Show: show user;

4) Alter user: alter user 'usename' identified by 'password';

5) Unlock user: alter user 'username' account unlock;

Read more
Reply
About
This topic belongs to the forum

  • IT based community for everyone, managed by the students of Institute of Information Technology(IIT), University of Dhaka.

  • Numbers of topics : 2170
  • Numbers of messages : 11613
  • Numbers of users : 1941
  • Numbers of points : 310
Similar topics
Basic unix Commands : Offline edition
Course code: 402 Course Name: Operating System and System Programming Summary: Materials from Stanford University's website, this topic distributes the computer section in a zipped format for educational purposes to students for convenient
Oracle Cards
Do you use them and if so do you think they are easier than tarot?
Installing Oracle 10G in ubuntu 10.04 LTS
Hi there First of all, collect the oracle 10G express edition debian installer from oracle. then at first install the debian library called libaio1_0.3.107-3ubuntu2_i386 Code:sudo apt-get install libaio1 then, install the oracle 10G express
Linux command in my everyday life
Linux command in my every day life: ls – directory and file listing ls -al formatted listing with hidden files cd [directory_name] change directory to directory_name cd goto home pwd - present working directory mkdir [directory_name] create a
The Well Worn Path Oracle
Anyone familiar with this deck?
Forums from same category
See also
more_less
Informations

6 Replies For the topic :
"Basic Commands for Oracle 10g"

This topic has been viewed 2769 times.

Last message :
11/07/2010 at 17h38 by "BIT0119-Asif"