Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ÓÖÁÁ點¶à¶à¡£

Äã¸ù據Äã×Ô¼ºµÄÇé況來進ÐÐ選&#


Ïà¹ØÎÊ´ð£º

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿

ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
        @SYS_ORGANIZE varchar(10), ......

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ