MySQL == Oracle

dATABASE in MySql is Schema/User in Oracle

SHOW DATABASES = SELECT USERNAME FROM ALL_USERS

SHOW TABLES (in a database ) = SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER=’Schema_Name’

http://www.velocityreviews.com/forums/t143186-oracle-equiv-of-mysql-show-tables-.html

Oracle Tools

datadump , export/import

sqlldr

dbca/netca/emca

OSWatcher

SQlDeveloper

Resources

http://orafaq.com, http://asktom.oracle.com

Advertisements

Leave a comment

Filed under DB

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s