1 连接数据库(通过service_name)
sqlplus user/pass@ip:1521/service_name
sqlplus user/pass@ip:1521/service_name
sqlplus user/pass@ip:1521/service_name
service_name不确定的话，需要区数据库服务器上查询。
lsnrctl然后输入service即可。
2 连接数据库(通过sid)
sqlplus user/pass@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ip)(PORT=1521))(CONNECT_DATA=(SID=sid)))"
sqlplus user/pass@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ip)(PORT=1521))(CONNECT_DATA=(SID=sid)))"
sqlplus user/pass@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ip)(PORT=1521))(CONNECT_DATA=(SID=sid)))"
3 查看用户所有表
SELECT TABLE_NAME FROM USER_TABLES;
SELECT TABLE_NAME FROM USER_TABLES;
SELECT TABLE_NAME FROM USER_TABLES;
4 查看用户可取的表
SELECT TABLE_NAME FROM ALL_TABLES;
SELECT TABLE_NAME FROM ALL_TABLES;
SELECT TABLE_NAME FROM ALL_TABLES;
5 查看表结构
DESCRIBE TABLE_NAME;
DESCRIBE TABLE_NAME;
DESCRIBE TABLE_NAME;
6