Oracle Launching Database:
Oracle 9i:
DOS> SQLPLUS "as sysdba"
SQLPlus> Startup
Oracle 8i:
DOS> SVRMGRL
SVRMGRL> Connect Internal
SVRMGRL> Startup
View the Oracle service name in the database:
SYSTEM account login, show parameter service_name
SQL Server Creates an ActiveX Object: Read C: /Boot.ini content below
declare @o int, @f int, @t int, @ret intdeclare @line varchar (8000) exec sp_oacreate 'scripting.filesystemobject', @o outexec sp_oamethod @o, 'opentextfile', @f out, 'c: / boot .ini ', 1exec @ RET = sp_oamethod @ f,' readline ', @ line outwhile (@ Ret = 0) beginprint @lineexec @ Ret = sp_oamethod @ f,' readline ', @ line Outend
Oracle's external connection
Also think that Oracle does not do the effect like LEFT JOIN in SQL Server, with WHERE A.FIELD1 = B.field2 When there is no Field1 data in Field2, the data in the table cannot be selected, it has only possible and impossible All enumerated, failed. I actually found the usage ( ) usage, reference
Some simple commands of Oracle and MySQL reference http://202.101.18.235/club/bbs/showssnce.asp?id=22161&page=2
SQL statement learning notes - external connection http://rofei.y365.com/tech/SQL_Study_3.htm
E.G. SELECT D.DEPT_NAME, E.EMP_LAST_NAME FROM EMP E, DEPT D, WHERE E.DEPT_NO = D.DEPT_NO ( ) ORDER BY D.DEPT_NAME, E.EMP_LAST_NAME;
