02 Oracle 常用SQL

1.获取时间

SQL> select sysdate from dual;

SYSDATE
--------------
30-10月-22

SQL>

2.查看SGA_TARGET参数值

SHOW PARAMETER SGA_TARGET

NAME                                 TYPE        VALUE
------------------------------------ ----------- -----
sga_target                           big integer 9728M

3.获取建表语句

select dbms_metadata.get_ddl('TABLE','表名') from dual;