Oracle·¢²¼Ãâ·ÑÊý¾Ý¿â¿ª·¢¹¤¾ßSQL Developer 1.2
Oracle·¢²¼Ãâ·ÑÊý¾Ý¿â¿ª·¢¹¤¾ßSQL Developer 1.2
2007.09.25 À´×Ô£ºCSDN¡¡ ÄŲ»º° ¹²ÓÐÆÀÂÛ()Ìõ ·¢±íÆÀÂÛ ÊÕ²Ø
Oracle SQL DeveloperÊǼ׹ÇÎĹ«Ë¾Ãâ·ÑÌṩµÄÊý¾Ý¿â¿ª·¢¹¤¾ß£¬¿É°ïÖúÓû§¼ò»¯¿ª·¢¹¤×÷£¬Ìá¸ß±àÖƺ͵÷ÊÔSQLºÍPL/SQL´úÂëµÄЧÂÊ¡£ÏÖÔÚ£¬Õâ¸öÃâ·Ñ¹¤¾ßÓÖÔö¼ÓÁË·½±ã´ÓµÚÈý·½Êý¾Ý¿âÏòOracleÊý¾Ý¿âǨÒƵÄй¦ÄÜ¡£
¡¾CSDN 9ÔÂ25ÈÕÏûÏ¢¡¿¼×¹ÇÎÄÓÚ½ñÌìÕýʽ·¢²¼Oracle SQL Developer 1.2°æ¡£1.2°æÐÂÔöÁ˲»ÉÙй¦ÄÜ£¬¼ò»¯ÁË´ÓµÚÈý·½Êý¾Ý¿âÏòOracleÊý¾Ý¿â11gµÄǨÒÆÒÔ¼°µÚÈý·½Êý¾Ý¿âÓëOracleÊý¾Ý¿â11gµÄÕûºÏ¡£
Oracle SQL DeveloperÊǼ׹ÇÎĹ«Ë¾Ãâ·ÑÌṩµÄÊý¾Ý¿â¿ª·¢¹¤¾ß£¬¿É°ïÖúÓû§¼ò»¯¿ª·¢¹¤×÷£¬Ìá¸ß±àÖƺ͵÷ÊÔSQLºÍPL/SQL´úÂëµÄЧÂÊ¡£ÏÖÔÚ£¬Õâ¸öÃâ·Ñ¹¤¾ßÓÖÔö¼ÓÁË·½±ã´ÓµÚÈý·½Êý¾Ý¿âÏòOracleÊý¾Ý¿âǨÒƵÄй¦ÄÜ¡£
ºÜ¾ÃÒÔÀ´£¬¼×¹ÇÎÄÒ»Ö±Ìṩ¶ÀÁ¢µÄǨÒƹ¤×÷̨¹¤¾ß£¬ÒÔ°ïÖúÊý¾Ý¿â¿ª·¢ÈËÔ±´Ó·ÇOracleÊý¾Ý¿âÏòOracleÊý¾Ý¿âǨÒÆ¡£Oracle SQL Developer 1.2°æ¼¯³ÉÁËÒ»¸ö¸ü¼ÓÇ¿´óµÄǨÒƹ¤×÷̨¹¤¾ß£¬¼´Oracle SQL DeveloperǨÒƹ¤×÷̨£¨Oracle SQL Developer Migration Workbench£©¡£Õâ¸öǨÒƹ¤×÷̨ΪÊý¾Ý¿â¿ª·¢ÈËÔ±ÌṩÁ˵¥Ò»µÄ¹¤¾ßºÍ»·¾³£¬ËûÃÇ¿ÉÒÔÓÃÕâ¸ö¹¤×÷̨ä¯ÀÀµÚÈý·½Êý¾Ý¡¢Ç¨ÒÆÊý¾Ý¿â¶ÔÏóºÍÊý¾Ý²¢ä¯ÀÀǨÒƺóµÄÊý¾Ý¿â£¬´Ó¶ø½µµÍ´ÓµÚÈý·½Êý¾Ý¿âÏòOracleÊý¾Ý¿âǨÒÆËùÐèµÄʱ¼ä¡¢³É±¾ÒÔ¼°ÓйطçÏÕ¡£
Oracle SQL DeveloperǨÒƹ¤×÷̨¾ßÓй㷺µÄÊý¾Ý¿âǨÒƹ¦ÄÜ¡£Óû§¿ÉÓÃÕâ¸ö¹¤×÷̨ǨÒƵ¥¸ö±í¸ñ»ò¼¸¸öÊý¾Ý¿â¡£Óû§Á¬½ÓÔÚÊý¾Ý¿âÉÏʱҲ¿ÉÒÔ½øÐÐǨÒÆ£¬»òÕßÓû§¿ÉÒÔÉú³ÉÏîÄ¿±í£¬½«Æä×÷ΪǨÒÆÏîÄ¿µÄ×é³É²¿·Ö£¬²¢ÓÃOracle SQL DeveloperµÄSQLºÍPL/SQL±àÖÆÓëµ÷ÊÔ¹¤¾ßÐÞ¸ÄÏîÄ¿±í¡£Oracle SQL DeveloperǨÒƹ¤×÷̨¾ßÓÐеÄÓï·¨·ÖÎö³ÌÐò£¬¿ÉÒÔ°Ù·ÖÖ®°Ùʶ±ðT-SQLÓï·¨¡£¸Ã¹¤×÷̨»¹¾ßÓе¥¸öÓï¾ä·ÒëÆ÷£¬Óû§¿ÉÒÔ½«ÈκÎÖÖÀàµÄT-SQLÓï¾äÕ³Ìùµ½±à¼Æ÷ÖУ¬²¢½«Æ伴ʱ·Òë³ÉPL/SQLÓï¾ä¡£
Oracle SQL DeveloperǨÒƹ¤×÷̨Ϊ¿ª·¢ÈËÔ±ÌṩÁËÁ½¸öǨÒÆÑ¡Ïî¡£Óû§¿ÉÒÔÓøù¤×÷̨¸½´øµÄʵÓÃÏòµ¼³ÌÐò½øÐе¥²½Ç¨ÒÆ£¬Ò²¿ÉÒÔ½«Ç¨Òƹý³Ì·Ö³É¼¸¸ö²¿·Ö£¬ÒÔÔÚÐèҪʱ¶Ô¸÷¸ö²»Í¬µÄ²¿·Ö½øÐÐͳһÐ޸ġ£Õâ¸ö¹¤×÷̨¿É°ïÖúÓû§½«ÒÔϵÚÈý·½Êý¾Ý¿âǨÒƵ½OracleÊý¾Ý¿â£º
·Microsoft SQL Server£¨°æ±¾7.0¡¢2000ºÍ2005£©£»
·Microsoft Access£¨°æ±¾97¡¢2000¡¢20
Ïà¹ØÎĵµ£º
×°ÁËÒ»Ò¹µÄÈí¼þ£¬ÏÈÊÇMySQL£¬myEclipse,Oracle ,²»¶ÏµÄ³ö´í£¬OracleServise²»ÄÜÆô¶¯£¬ºÜÊÇ·³ÈË£¬Ð¶ÔØÁËOracelÁ½´Î£¬ÓÖÖØ×°£¬´íÎóµÃµ½Ò»Ð©½â¾ö£¬×¢²á±í³öÏÖÁ˺öàµÄÎÊÌ⣬ÒÔÇ°ÔÚжÔØÈí¼þµÄʱºò£¬¶¼Ã»ÓÐÓÃרÓõŤ¾ß£¬×¢²á±íÒ»ÍÅÂÒ£¬ÕæÊÇÏ൱µÄºó»Ú£¬ÏÖÔÚ¿´À´ÒªÏë¸Ä¹ýÀ´È·ÊµÊǺÜÄѵÄÀ²£¡ÒÔºóÕâ·½ÃæÒª¶à¼ ......
//tree.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Syst ......
osql ʵÓù¤¾ß
osql ʵÓù¤¾ßʹÄúµÃÒÔÊäÈë Transact-SQL Óï¾ä¡¢ÏµÍ³¹ý³ÌºÍ½Å±¾Îļþ¡£¸ÃʵÓù¤¾ßͨ¹ý ODBC Óë·þÎñÆ÷ͨѶ¡£
Óï·¨
osql
[-?] |
&nb ......
C# Êý¾Ý¿âÖ®ÂÃ……
¼ÌÐø½ø¹¥²ã³ö²»ÇîµÄproblems
ÔÚÉÏһƪÄÚÈݵĻù´¡ÉÏ£¬ÎÒÓÖ×÷ÒԸĽø£¬ÏÖÔÚµÄÇé¿öÊÇÕâÑùµÄ£º
//In Browseuser form
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System ......