- 浏览: 84264 次
- 性别:
- 来自: 深圳
文章分类
最新评论
-
guji528:
可以这样监控某Oracle用户已执行的sql:
--TEST用 ...
v$sql,v$sqlarea,v$sqltext区别 -
xiaoliu216:
印象深刻。。。
爱情守则
--java source hasn't return value
create or replace and compile java source named TestJava1 as
public class TestJavaHank1
{
public static void entry()
{
System.out.println("I am maxiaohu!");
}
}
--java source has return value
create or replace and compile java source named TestJava2 as
public class TestJavaHank2
{
public static String entry(String name)
{
return "你好:"+name;
}
}
create or replace procedure testjava as language java name 'TestJavaHank.entry()';
create or replace function testjava2(name varchar2) return varchar2
as language java name 'TestJavaHank2.entry(java.lang.String) return java.lang.String';
--在oracle中加载编译过的class文件
create or replace function testCode(name varchar2) return varchar2
as language java name 'test.getCode(java.lang.String) return java.lang.String';
--外部java类 启动enterprise manageconsole,
--在“方案”下找到“源类型”,右击”java类”,
--选择”加载java“,选择对应的class文件即可。
public class test
{
public static String getCode(String name)
{
return "123"+name;
}
}
--call procedure
begin
testjava;
end;
--command window
SET SERVEROUTPUT ON;
CALL dbms_java.set_output(2000);
exec testjava;
--call function
begin
dbms_output.put_line(testCode('maxiaohu'));
end;
create or replace and compile java source named TestJava1 as
public class TestJavaHank1
{
public static void entry()
{
System.out.println("I am maxiaohu!");
}
}
--java source has return value
create or replace and compile java source named TestJava2 as
public class TestJavaHank2
{
public static String entry(String name)
{
return "你好:"+name;
}
}
create or replace procedure testjava as language java name 'TestJavaHank.entry()';
create or replace function testjava2(name varchar2) return varchar2
as language java name 'TestJavaHank2.entry(java.lang.String) return java.lang.String';
--在oracle中加载编译过的class文件
create or replace function testCode(name varchar2) return varchar2
as language java name 'test.getCode(java.lang.String) return java.lang.String';
--外部java类 启动enterprise manageconsole,
--在“方案”下找到“源类型”,右击”java类”,
--选择”加载java“,选择对应的class文件即可。
public class test
{
public static String getCode(String name)
{
return "123"+name;
}
}
--call procedure
begin
testjava;
end;
--command window
SET SERVEROUTPUT ON;
CALL dbms_java.set_output(2000);
exec testjava;
--call function
begin
dbms_output.put_line(testCode('maxiaohu'));
end;
发表评论
-
Hp unix中问题解决方案讲解
2010-08-13 18:29 1062当我们经常操作Hp unix的时候,就会遇到在操作系统上rm掉 ... -
HP-UX下删除文件无法释放空间
2010-08-13 18:28 24901 引言 很多人会遇到在操作系统上rm掉一个大的文件,以解决 ... -
v$sql,v$sqlarea,v$sqltext区别
2009-12-17 13:11 3064v$sqltext 存储的是完整的SQL,SQL被分割 SQ ... -
oracle SYS_CONTEXT列表
2009-10-16 10:27 940select SYS_CONTEXT('USERENV', ... -
Oracle CONNECT BY 循环 错误
2009-10-10 23:16 1610java.sql.SQLException: ORA-0143 ... -
Oracle创建索引要做到三个适当
2009-09-28 11:59 2384在Oracle数据库中,创建 ... -
分布式oracle中databaselink
2009-09-21 20:31 1151数据库链接定义从一个Oracle数据库到另一个数据库的单行通信 ... -
create oracle package
2009-09-20 14:15 4255一、程序包的相关知识 1.定义与说明 a. 相关对象的封装 ... -
Procedure to kill a session
2009-09-07 22:31 1004On the Oracle-L mailing list a ... -
oracle 动态SQL
2009-09-06 19:47 747sql_update := 'update ' || tabl ... -
1.Oracle游标大全;2.分析Oracle日志文件
2009-07-17 16:28 13031.Oracle游标大全 SELECT语句用于从数据库 ... -
PI 实时数据库系统
2009-07-17 10:21 2320PI 实时数据库系统(Plant Information Sy ... -
rlwrap使用方法
2008-12-04 15:45 1126在Windows操作系统上,当在DOS命令窗口中运行SQL*P ... -
recovery
2008-09-27 15:31 704Understanding the types of fail ... -
backup
2008-09-27 15:30 758The control files contain the m ... -
Database Maintenance
2008-09-24 16:11 771Oracle 10g provides many tools ... -
Assigning a Profile to a User
2008-09-19 15:04 924A profile serves two purposes: ... -
Sizing the Large Pool
2008-09-19 09:35 707select sum(value) "Max MTS ... -
Oracle Net manages
2008-09-18 12:06 1063Oracle Net manages the flow of ... -
Heterogeneous Services
2008-09-16 12:12 785Heterogeneous Services provide ...
相关推荐
Navicat Premium combines the functions of other Navicat members and supports most of the features in MySQL, SQL Server, SQLite, Oracle and PostgreSQL including Stored Procedure...
Code refactoring - Extract sub procedure definition from procedural code - 3 clicks method for conversion of a block of code to a stored procedure or function - customizable templates. Code ...
SQL Server, SQLite, Oracle and PostgreSQL including Stored Procedure, Event, Trigger, Function, View, etc. Navicat Premium enables you to easily and quickly transfer data across various database ...
tibero6 數據管理手冊 英文版, 韓國最大數據庫tibero, 和Oracle相容度高達98%以上,oracle stored procedure, package, function , db trigger, partition tables都能順利無痛移轉完成
tibero6 數據庫安裝手冊 英文版, 韓國最大數據庫tibero, 和Oracle相容度高達98%以上,oracle stored procedure, package, function , db trigger, partition tables都能順利無痛移轉完成
Values to which NCHAR, NVARCHAR2, or NCLOB columns are modified may be unnecessarily converted to the database character set before being converted to the national character set and stored in the ...
tibero6 數據庫連接大數據手冊 英文版, 韓國最大數據庫tibero, 和Oracle相容度高達98%以上,oracle stored procedure, package, function , db trigger, partition tables都能順利無痛移轉完成
Navicat Premium combines the functions of other Navicat members and supports most of the features in MySQL, SQL Server, SQLite, Oracle and PostgreSQL including Stored Procedure...
Navicat Premium combines the functions of other Navicat members and supports most of the features in MySQL, SQL Server, SQLite, Oracle and PostgreSQL including Stored Procedure...
但对应用更加广泛、机制更加复杂的ORACLE 数据库服务就有一些困难,如果想作一些简单的查询功能,ADO是足够的,如要想更好地发挥ORACLE数据库特有的功能,如STORED PROCEDURE,STORED FUNCTION等就要采取利用ASP...
* Using collections containing component references and form inheritance can result in incorrect references being stored in the dfm file.======================================================= CORE ...
3.3. Java 8 (as well as 6 and 7) ............................................................................... 17 3.4. Java EE 6 and 7 ..................................................................
3.3. Java 8 (as well as 6 and 7) ............................................................................... 17 3.4. Java EE 6 and 7 ..................................................................