jdbcÖе÷ÓÃoracle´æ´¢¹ý³Ì
1¡¢´´½¨±í£º
create table stud(
sid int,
sname varchar2(50)
)
²¢²åÈëÒ»ÌõÊý¾Ý
insert into stud values(1,'Tom')
2¡¢´´½¨´æ´¢¹ý³Ì
--´´½¨´æ´¢¹ý³Ì
create or replace procedure pro_select_name(
v_sid in stud.sid%type,
v_sname out stud.sname%type
)
--ÉùÃ÷Çø
is
--Ö´ÐÐÌå
begin
select sname into v_sname from stud where sid = v_sid;
--Òì³£´¦Àí
exception
when others then
dbms_output.put_line(sqlcode||sqlerrm);
end;
3¡¢jdbcÖе÷ÓÃ
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Types;
public class TestPro {
public void test(){
Connection con = null;
CallableStatement cst = null;
try{
 
Ïà¹ØÎĵµ£º
1. ½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄ
Êý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½ÈÎÒâÒ»¸öʱ¼äµã¡£À䱸·ÝµÄÓŵãÔÚÓÚËüµÄ±¸·ÝºÍ»Ö¸´
²Ù×÷Ïൠ......
ϵͳȨÏÞ£º »ØÊÕʱ²»»á²úÉú¼¶Áª»ØÊÕ
conn / as sysdba;
create user t1 identified by t1;
create user t2 identified by t2;
grant connect to t1,t2;
grant create table, create view to t1 with admin option;
conn t1/t1
grant create table to t2;
conn / as sysdba;
select * from dba_sys_privs where gra ......
ÒÆ¶¯±íËùÔÚ±í¿Õ¼ä£º
alter table table_name(±íÃû£© move tablespace new_tablespace(бí¿Õ¼ä£©
Óû§ÓµÓеĴ洢¹ý³Ì£º
select object_name from user_objects where object_type='PROCEDURE'; ......
£¨´ËƪÎÄÕÂÖ»ÐèÒªÁ˽â¼È¿ÉÒÔÁË£©
ǶÌ×±í
¶¨Ò壺ÔÚÒ»¸ö±íÖл¹°üº¬ÁíÍâÒ»¸ö×Ó±í¡£
Êý¾Ý¿âÔÚ´´½¨Êý¾Ý±íµÄʱºò¶¼ÒªÖ¸¶¨×ֶεÄÀàÐÍ£¬ËùÒÔǶÌ×±í±¾ÉíÒ²ÐèҪͬÑùÖ¸¶¨ÀàÐÍ£¬ËùÒÔÕâÖÖÀàÐÍÐèÒªµ¥¶À¶¨Òå¡£
´´½¨ÀàÐÍÓï·¨£ºcreate type project_ty as object£¨
......
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip
Oracle9i ......