oracle常用sql

    xiaoxiao2021-03-25  135

    1,查看数据库实例名

      SELECT NAME FROM V$DATABASE;

    2,查看用户名

    select username from dba_users;

    3,查看当前schema

    select SYS_CONTEXT('USERENV','CURRENT_SCHEMA') CURRENT_SCHEMA from dual;

    转载请注明原文地址: https://ju.6miu.com/read-8862.html

    最新回复(0)