Oracle基础一:dba_source all_source描述该用户能访问的对象。 user_source描述用户自己的对象。 dba_source描述所有系统存储的对象。 包括其它对象同样遵循该命名法则。 其中描述的对象包含以下内容: PROCEDURE PACKAGE PACKAGE BODY LIBRARY TYPE BODY TRIGGER FUNCTION JAVA SOURCE TYPE 其它的一些对象的语句可以通过dbms_metadata.get_ddl()来获得。包括table,view,db_link...
查看JOB信息:user_jobs、all_jobs、dba_jobs 查看所有对象信息(过程PROCEDURE、函数FUNCTION、包和包体、JOB和LOB大字段、表、视图、索引、序列、触发器):user_objects、all_objects、dba_objects 查看过程、函数、触发器、包和包体内容:user_source、all_source、dba_source 特殊语句: --查看建表语句 SELECT DBMS_M...
Search all events AI and ML APIs Blockchain Chatbots Container technologies Databases DevOps HeatWave Infrastructure as code Linux Low code Microservices Open source Visual Builder Technologies Oracle gives you the power, flexibility, and reliability needed to create the best products and services availab...
开发中用存储过程的朋友可能会用到: ORACLE数据库的SQL如下: SELECT * FROM ALL_SOURCE t WHERE t.TYPE = 'PACKAGE BODY' AND t.TEXT LIKE '%TableName%'; MSSQL数据库的SQL如下: SELECT DISTINCT objec...
Technologies See all technologies AI and ML Databases DevOps HeatWave Low code Open sourceCommunity and events Developer Coaching series Developer Coaching is a webinar series designed for technologists, by technologists. Learn by doing, with live, interactive sessions showcasing real-world solutions. ...
AllSource 1.2| 要从ArcGIS 客户端连接到Oracle,在 ArcGIS 客户端计算机上安装Oracle客户端,设置引用Oracle客户端的环境变量,并从 ArcGIS 创建数据库连接。 如需发布引用ArcGIS Server数据库中数据的Oracleweb 服务,请将数据库连接文件注册到您的ArcGIS Server站点。
Esri ST_Geometry 空间数据类型是 Oracle 中地理数据库的默认几何存储类型。 还可以使用创建空间类型地理处理工具,在 Oracle 数据库中安装 ST_Geometry 类型。 注: Oracle XA 事务不支持 ST_Geometry 类型。 要在Oracle 数据库管理系统中创建地理数据库并使用 ST_Geometry 类型和域索引,必须授予地理数据库管理员用户...
Oracle source custom properties The custom properties of the Oracle source are as below. All properties are read/write. Expand table Property NameData TypeDescription AccessMode Integer (enumeration) The mode used to access the database. The possible values are Table Name and SQL Command. The ...
Oracle Java is the #1 programming language and development platform. It reduces costs, shortens development timeframes, drives innovation, and improves application services. Java continues to be the development platform of choice for enterprises and developers. ...
Java Certification and Training Java Bug Database The Java Source Blog @Java Java Developer Newsletter Demos and videos Community Platform Java User Groups Java Champions Java Community Process Explore More Java Newsletter Inside Java Podcast Attend an event...