oracle sql common好用 常用
SELECT machine,
terminal
FROM v$session;
SELECT *
FROM v$locked_object
SELECT NAME
FROM v$database;
SELECT SYS_CONTEXT('userenv', 'ip_address')
FROM DUAL;
SELECT *
FROM dba_db_links;
SELECT *
FROM nls_database_parameters;
SELECT *
FROM v$nls_parameters;
CREATE TABLE new_table AS (SELECT * FROM old_table);