oracle中用comment on命令给表或字段加以说明,语法如下:COMMENT ON { TABLE [ schema. ] { table | view } | COLUMN [ schema. ] { table. | view. | materialized_view. } column | OPE
常用数据库 JDBC URL 格式Microsoft SQL ServerMicrosoft SQL Server JDBC Driver (一般用来连接 SQLServer 2000)驱动程序包名:msbase.jar mssqlserver.jar msutil.jar驱动程序类名: com.microsoft.jdbc.sqlserver.SQLServerDriverJDBC URL: j
1.查看表空间使用情况:select sum(bytes)/(1024*1024) as free_space,tablespace_name from dba_free_space group by tablespace_name;SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE, &nb
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号