SELECT DBMS_METADATA.GET_DEPENDENT_DDL ('INDEX', TABLE_NAME, TABLE_OWNER) FROM (SELECT table_name, table_owner FROM Dba_indexes WHERE table_owner = UPPER (TRIM('&TABLE_OWNER')) AND table_name = UPPER (TRIM('&TABLE_NAME')) AND index_name NOT IN (SELECT constraint_name FROM DBA_CONST...
它用来提取数据库对象(如 TABLE、VIEW、INDEX、PROCEDURE、SEQUENCE、TRIGGER、SYNONYM、FUNCTION、PACKAGE 等)的 DDL(Data Definition Language)语句。 GET_xxx 函数用于通过一次调用获取对象的元数据。目前 OceanBase 数据库当前版本仅支持 GET_DDL。 功能适用性 该内容仅适用于 OceanBase 数据库企业版。OceanBase 数据库...
SQL_MAX_TABLE_NAME_LEN SQL_MAX_TABLES_IN_SELECT SQL_MAX_USER_NAME_LEN 标量函数信息 InfoType 参数的以下值返回有关数据源和驱动程序支持的标量函数的信息。 有关标量函数的详细信息,请参阅 附录E:标量函数。 SQL_CONVERT_FUNCTIONS SQL_NUMERIC_FUNCTIONS SQL_STRING_FUNCTIONS SQL_SYSTEM_FUNCTIONS SQL_TIMEDA...
例如,ORACLE 驅動程式是兩層驅動程式。SQL_FILE_TABLE = 單一層驅動程式會將數據源中的檔案視為數據表。 例如,Xbase 驅動程式會將每個 Xbase 檔案作為資料表。SQL_FILE_CATALOG = 單層驅動程式會將數據源中的檔案視為目錄。 例如,Microsoft Access 驅動程式將每個 Microsoft Access 檔案視為完整的資料庫。應用程式...
Get all table columns get /database/objects/columns/Returns all records from DBA_TAB_COLUMNS or ALL_TAB_COLUMNS view depending on role at runtime. Records included in the response describes the columns of all tables, views, and clusters that the role has access to. A client requires ...
Get all procedures defined in package Get all synonyms in the database Get all table columns Get all tables Get an argument Get an object type Get information on a specific materialized view log Data Guard Data Pump Environment General Monitoring Open Service Broker Oracle APEX Performance Pluggable...
In 12.0.4 when running Register Extra Information Types (EITs) with the following parameter : Table Name : HR_ORG_INFORMATION_TYPES Then you get the following error : ERROR APP-FND-01564: ORACLE error 24345 in fdlget Cause: fdlget failed due to ORA-24345: A truncation or null fetch erro...
')from dba_tab_cols a,dba_col_comments b,dba_tab_comments cwhere a.table_name='DML_SD_BANK_GL'and a.owner = 'UUPSDB2'and a.owner = b.ownerand b.owner = c.ownerand a.table_name = b.table_nameand a.column_name = b.column_nameand a.table_name = c.table_nameorder by a....
The following table alphabetically lists each information type, the version of ODBC in which it was introduced, and its description. Expand table Information TypeODBC VersionDescription SQL_ACCESSIBLE_PROCEDURES 1.0 A character string: "Y" if the user can execute all procedures returned by SQLProced...
schemaPattern - a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search tableNamePattern - a table name pattern; must match the table name as it ...