ʹÓÃoracleµÄjavaJVM£¬trigger
create or replace java source named FirstClass as
public class FirstClass{
public static String greeting(String name){
return "Hello " + name + "!";
}
}
/
create or replace function firstclass_greeting (name varchar2) return varchar as
language java name 'FirstClass.greeting(java.lang.String) return java.lang.String';
/
SQL> select firstclass_greeting('Bruce') from dual;
FIRSTCLASS_GREETING('BRUCE')
--------------------------------------------------------------------------------
Hello Bruce!
========================================
Listing 4. The Source Code for create_bookstore_tables.sql
drop table books
/
drop table publisher_supply_orders
/
create table books(
book_id number primary key,
publisher_id number,
page_count number,
author_name varchar2(50),
book_title varchar2(50),
description varchar2(500),
status varchar2(10),
inventory_qty number
)
/
insert into books values(100, 200, 234, 'Bruce Hopkins', 'Bluetooth for Java', 'great book', 'IN STOCK', 10);
insert into books values(101, 200, 401, 'Sam Jones', 'Living on the East Coast', 'worth every penny', 'IN STOCK', 50);
insert into books values(102, 250, 278, 'Max Jason', 'The South of France', 'a best-seller', 'IN STOCK', 20);
create table publisher_supply_orders(
book_id number,
publisher_id number,
order_quantity number
)
/
=================
create or replace java source named "ReorderTrigger" as
import java.sql.*;
import oracle.jdbc.driver.*;
public class ReorderTrigger {
public static int REORDER_THRESHOLD = 5;
public static int REORDER_QTY = 25;
public static void reorderBooks(Integer bookID, Integer publi
Ïà¹ØÎĵµ£º
Oracle¹ÜÀíÔ±µÄÁ½ÖÖÈÏÖ¤·½·¨
×¢Òâ£ºÖØÒª
parameter ÖÐremote_login_passwordfile
1¡¢alter system set remote_login_passwordfile= none scope =spfile£»
º¬Ò壺·ÇÃÜÂëÈÏÖ¤£¨´Ëʱ½öosÈÏÖ¤ £©
2¡¢alter system set remote_login_passwordfile= exclusive ......
ʱ¼ä: 2006-06-15 À´×Ô£ºCSDN
< type="text/javascript"><!--
google_ad_client = "pub-0103898066674568";
google_ad_width = 728;
google_ad_height = 90;
google_ad_format = "728x90_as";
google_ad_type = "text";
google_ad_channel = "";
google_color_ ......
/*============´´½¨Customer±í==========*/
create table Customer
(
Customer_id number(6) not null,
Customer_name varchar2(50) not null,
Password varcha ......
DECODEº¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLʵÏÖ»¹Ã»Óд˹¦ÄÜ¡£DECODEÓÐʲôÓÃ; ÄØ£¿ Ïȹ¹ÔìÒ»¸öÀý×Ó£¬¼ÙÉèÎÒÃÇÏë¸øÖÇÐÇÖ°Ô±¼Ó¹¤×Ê£¬Æä±ê×¼ÊÇ£º¹¤×ÊÔÚ8000ÔªÒÔϵĽ«¼Ó20£¥£»¹¤×ÊÔÚ8000ÔªÒÔÉϵļÓ15£¥£¬Í¨³£µÄ×ö·¨ÊÇ£¬ÏÈÑ¡³ö¼Ç¼ ÖеŤ×Ê×Ö¶ÎÖµ? select ......
=================================================================================
Oracle RAC ²úÆ·¸ÅÊö
Oracle Real Application Server£¬ÕæÕýÓ¦Óü¯Èº£¬¼ò³ÆOracle RAC £¬ÊÇOracleµÄ²¢Ðм¯Èº£¬Î»ÓÚ²»Í¬·þÎñÆ÷ϵͳµÄOracleʵÀýͬʱ·ÃÎÊͬһ¸öOracleÊý¾Ý¿â£¬½ÚµãÖ®¼äͨ¹ý˽ÓÐÍøÂç½øÐÐͨÐÅ£¬ËùÓеĿØÖÆÎļþ¡¢Áª»úÈÕÖ ......