oracle笔记

登陆方式:

sqlplus username/pwd as sysdba; 让用户以管理员身份登陆
sqlplus /@实例名 as sysdba; 直接以管理员身份登陆
sqlplus username/pwd@host_id:1521/实例名; 普通用户登陆

sqlplus /nolog;
conn username/pwd@host_id:1521/实例名;

查看表名称:

select table_name from user_tables;
select table_name from all_tables where owner=upper(‘scott’);

Leave a Reply

Your email address will not be published.