ÉèÖÃOracleÌáʾ·û
ÔÚ$ORACLE_HOME/sqlplus/admin/login.sql (»òÕßÊÇglogin.sql)ÖÐÌí¼Ó£º
set termout off
COLUMN prompter new_value m_prompt
select host_name || ':' || instance_name ||' >' prompter
from sys.v_$instance;
set sqlprompt '&m_prompt'
set termout on
Ïà¹ØÎĵµ£º
select nvl2(replace(translate('69584.00.00','.0123456789','000000000000'),'0',''),'·ñ','ÊÇ') IsNumber from dual;
select id,nvl2(replace(translate(id,'.0123456789','000000000000'),'0',''),'·ñ','ÊÇ') IsNumber
from tbl2 ......
/*============´´½¨Customer±í==========*/
create table Customer
(
Customer_id number(6) not null,
Customer_name varchar2(50) not null,
Password varcha ......
ÔÚOracle 9iÖпÉÒÔ·½±ãµÄ°ÑÊý¾Ýµ¼³öΪÎļþ£¬»òÕß´ÓÎļþµ¼È롣ͨ¹ýOracleµÄÖÎÀí·þÎñÆ÷£¨Oracle Management Server£¬OMS£©¿ÉÒÔ·½±ãµÄʵÏÖ£¬Õû¸ö²Ù×÷¹ý³ÌÖÐÓÐºÜ¶àµØ·½ÐèÒª½âÊÍ˵Ã÷£¬µ«ÊÇÍêÕûµÄÖ¸µ¼×ÊÁϲ»¶à¡£¸÷´óÂÛ̳ÉϺܶàËùνµÄ¸ßÊÖ£¬¶Ô¸ÃÖ÷ÌâµÄ»Ø´ðÍùÍùÊÇ£¬¸ßÊÖÊDz»ÓÃOMSµÄ£¬ÓÃeXP/impl°É¡£¼ÙÈçÄãÖ´Òâ×·ÎÊ£¬Ëû¶à°ë»á¸æËßÄ㣠......
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) ret ......
OracleÆô¶¯¹ý³Ì½éÉܼ°ÃüÁ»¹Óйرա£
дÔÚÇ°Ãæ£ºÆô¶¯Êý¾Ý¿âǰ£¬ÇëÏÈÆô¶¯¼à³ÌÐò¡£
lsnrctl start
Æô¶¯µÄÈý¸ö²½Ö裬ÒÀ´ÎΪ1.´´½¨²¢Æô¶¯ÊµÀý¡¢2.×°ÔØÊý¾Ý¿â¡¢3.´ò¿ªÊý¾Ý¿â¡£
¿ÉÒÔͨ¹ýÃüÁîstartupÀ´ÊµÏÖ¡£
startup ÃüÁî¸ñʽ
startup [ nomount | mount | open | force ] [ restrict ] [ pfile=filename ];
·½·¨1 -- st ......