MSSQL网站制作之Is iSQL Plus running

对于update操作，只需要把event中的旧行和新行值对调即可。iSQL*PlusPage
iSQL*PlusisaproductindependentofEnterpriseManager.TheiSQL*PlususerinterfacerunsinawebbrowserconnectedtotheInternetoryourintranet.iSQL*PlusenablesyoutouseawebbrowsertoconnecttoanOracledatabaseandperformthesameactionsasyouwouldthroughthecommandlineversionofSQL*Plus(knownasSQL*Plusinthisguide).YoucanuseiSQL*PlustowriteSQL*Plus,SQLandPL/SQLcommandsto:

Enter,edit,runandsaveSQLcommandsandPL/SQLblocks.

Calculate,andprintqueryresults.

YoucanusetheiSQL*PlusWorkspacetowrite,load,saveandexecutescripts.YoucanenterscriptsasyouwouldincommandlineSQL*Plus.ThescriptoutputcanbedisplayedintheWorkspacescreenorsavedtoafileonyourclientmachine.

TheiSQL*Plusapplicationcanbeusedbytwotypesofusers;adatabaseuserwithNORMALroleandaWebDBAuser.Forsecurityreasons,ifyouwanttoconnectasSYSOPERorSYSDBA,youmustcreateandconfigureaWebDBAuserthatisHTTPauthenticated.

ConfiguringiSQL*Plus

IfyoureceiveanerrormessagepageafteryouclicktheiSQL*PluslinkontheDatabaseHomepage,youshouldcheckthefollowing:
IsiSQL*Plusconfiguredproperly?
ForGridControl,iSQL*PluswillnotbeshippedwiththeOMS(OracleManagementServer).SoiSQL*Plusneedstobemanuallyconfiguredtopointtoanyrunning10GiSQL*Plusserver.AllthetargetdatabasesdiscoveredinthisGridControlapplicationwillusethisiSQL*Plusserverfortheirqueries.

ForDatabaseControl,theiSQL*PlusinstallationwillautomaticallyconfiguretousetheiSQL*Plusservershippingwiththistarget.

ToconfigureiSQL*Plus,twoentriesinthe$ORACLE_HOME/sysman/config/emoms.propertiesfileontheOMS(OracleManagementServer)machineneedstobepopulatedbyreplacingthefollowingplaceholders:replace%ISQLPLUS_PROTOCOL%,%ISQLPLUS_HOST%and%ISQLPLUS_PORT%withtheprotocol,thehostandtheportoftheiSql*Plusserveryouwanttouse.

ForadatabaseuserwithNORMALrole:
oracle.sysman.db.isqlplusUrl=%ISQLPLUS_PROTOCOL%://%ISQLPLUS_HOST%:%ISQLPLUS_PORT%/isqlplus/dynamic

ForadatabaseuserwithSYSOPERandSYSDBArole(requiresadditionalsetupforiSQL*PlusDBAaccess):
oracle.sysman.db.isqlplusWebDBAUrl=%ISQLPLUS_PROTOCOL%://%ISQLPLUS_HOST%:%ISQLPLUS_PORT%/isqlplus/dba/dynamic

Forexample:

oracle.sysman.db.isqlplusUrl=http://chablis.au.oracle.com:5560/isqlplus/dynamic

oracle.sysman.db.isqlplusWebDBAUrl=http://chablis.au.oracle.com:5560/isqlplus/dba/dynamic

ForRACapplications,theemoms.propertiesfileforallnodesoftheclustermustalsohavethesetwoentriesconfigured.

Afterconfiguringtheentries,theOMSneedstoberestartedtopickupthechange.
IsiSQL*Plusrunning?
IfiSQL*Plusisnotstarted,youmaystartiSQL*Plususingthecommand:

$ORACLE_HOME/bin/isqlplusctlstart
IsiSQL*PlusDBAAccessSetup?
IfiSQL*Plusisconfiguredproperly,theiSQL*PlusConnectionRolepagepromptsyoutoselecttheroleyouwanttousetoconnecttoiSQL*Plus--Normal,SYSOPER(WebDBA)orSYSDBA(WebDBA).

ToconnectasSYSOPERorSYSDBA,theWebDBAusermustbesetupandauthenticatedusingtheOracleJAASProvider,knownasJAZN(JavaAuthoriZationN).ThisisOraclesimplementationoftheJavaAuthenticationandAuthorizationService(JAAS).WheniSQL*PlusWebDBAURLisinvoked,youmustenteravalidJAZNusernameandpasswordinadialogtogainaccesstotheiSQL*PlusDBAURL.ThisusernameandpasswordmaybedifferenttotheusernameandpasswordforyourOracledatabaseinstance.

ForinstructionsonhowtosetupaccesstoiSQL*PlusDBAURL,seetheSQL*PlusUsersGuideandReference.

Formoreinformationaboutthejaznadminsetup,seetheiSQL*PlusInstallationandConfigurationguideorgoto:

wiggum.ce.columbia.edu:7778/iplus/help/us/toc.htm
操作被同步到从库上后，则主从都“回天无力”。

你觉得我的非分区索引无法对起子分区，你可以提醒我一下呀！没有任何的提醒，直接就变成了非分区表。不知道这算不算一个bug。大家也可以试试。

如果是将来做数据库的开发设计，就应该详细学习T-SQL的各种细节，包括T-SQL的程序设计、存储过程、触发器以及具体使用某个开发语言来访问数据库。

如果，某一版本可以提供强大的并发响应，但是没有Oracle的相应版本稳定，或者价格较贵，那么，它就是不适合的。

多走走一此相关论坛，多看一些实例开发，多交流0经验，没什么的，我也是刚学没多久!加油

大侠们有推荐的书籍和学习方法写下吧。

分区表效率问题肯定是大家关心的问题。在我的试验中，如果按照分区字段进行的查询（过滤）效率会高于未分区表的相同语句。但是如果按照非分区字段进行查询，效率会低于未分区表的相同语句。

对递归类的树遍历很有帮助。个人感觉这个真是太棒了！阅读清晰，非常有时代感。

原来公司用过MYSQL自己也只是建个表写个SQL