PL/SQL DEVELOPERÓëORACLE SQLDEVELOPERÄĸö¸üºÃÓã¿
´ó¶àÊýÈ˶¼ÍƼöPL/SQL DEVELOPER£¬µ«ÊÇÒ²ÓеÄ˵ORACLE SQLDEVELOPERÓÃ×Å˳ÊÖ
ËûÃǹ¦ÄÜÉÏÓÐÊ²Ã´Çø±ðÂð£¿
ºÇºÇºÇ£¬Ã¿個ÈË對¹¤¾ßµÄÁ˽â³Ì¶È²»Í¬£¬對¹¤¾ßµÄϲºÃÒ²會Óвî異¡£
ÎÒ兩種¹¤¾ß¶¼ÓÃ過£¬´óÖÂÉϹ¦Äܶ¼ÊÇÒ»樣µÄ£¬ÎÒ¾Í談談²î異°É
plsql還ÊDZÈ較Ö÷Á÷µÄ£¬ÔÚ開發ºÍ¹ÜÀíÉ϶¼±È較·½±ã£¬還Ö§³Ö導Èë¡£導³ö¹¦ÄÜ£¬ ²»過ÐèÒª°²裝OracleµÄ¿Í戶¶Ë£¬²¢ÇÒÐèÒªÅäÖÃtnsname¡£這ÊÇÎÒ覺µÃ£¬ËûÉÔ΢Èõ勢µÄÒ»點¡£
Oracle psql devÄØ£¬ÊÇOracle×Ô帶µÄ¹¤¾ß£¬11gÒÑ經內Ƕµ½數據庫µÄ°²裝ÀïÈ¥ÁË£¬Ò²Ìṩ±È較ºÃµÄ開發ºÍ¹ÜÀíµÄ¹¦ÄÜ£¬µ«ÊÇÏà對plsql來說£¬ÒªÈõһЩ£¬²»過ÆäÖÐ帶ÓеÄmigration toolsÊÇÎÒ鐘ÇéÓڴ˹¤¾ßµÄÒ»點¡£ ¿ÉÒÔ對異構»òÕßͬ構µÄ數據庫進ÐÐ數據遷ÒÆ£¬ÎÒÔÚmysqlºÍms sqlÉ϶¼×ö個²»ÊǺÜ復雜µÄ遷ÒÆ£¬還ÊǺܷ½±ãºÍ實Óõ쬶øÇÒ該¹¤¾ß×îºÃµÄÒ»點ÊÇ java開發£¬Ê¹ÓõÄjdbcµÄ連½Ó·½Ê½£¬ËùÒÔ¼´Ê¹沒Óа²裝¿Í戶¶ËÒ²¿ÉÒÔͨ過thinµÄ·½Ê½連½Ó
這兩個¹¤¾ßÔÚ開發ºÍ¹ÜÀíÉÏ plsql dev 勝³öÒ»籌
µ«ÊÇÔÚ遷ÒÆ¹¦ÄÜºÍ¿çÆ½臺ÉÏ sql devÓÖÁÁ點¶à¶à¡£
Äã¸ù據Äã×Ô¼ºµÄÇé況來進ÐÐ選
Ïà¹ØÎÊ´ð£º
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
@SYS_ORGANIZE varchar(10), ......
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......