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

¸ü¸ÄSql*plusµÄÌáʾ·û

  Õý³£µÇ½sql*plusµÄ²½ÖèÈçÏ£º
sbdatabase*orcl-/home/oracle>sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on Sun May 9 19:50:24 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn hmsimis/test@orcl
Connected.
SQL>
¿ÉÒÔ¿´µ½Ç°ÃæµÄÌáʾ·ûÊÇSQL£¬ÏÖÔÚÏëÐÞ¸ÄÌáʾµÄÄÚÈÝ£¬¸ÃÔõô°ì£¿ÔÚoracle10gÖÐÒѾ­ÎªÎÒÃÇÌṩÁ˼¸¸öÔ¤Ïȶ¨ÒåµÄ±äÁ¿¿ÉÒÔÈÃÎÒÃÇÓÃÀ´ÏÔʾ£¬±ÈÈçÏÂÃæÕâÑù£º
SQL> define
DEFINE _DATE = "09-MAY-10" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "orcl" (CHAR)
DEFINE _USER = "HMSIMIS" (CHAR)
DEFINE _PRIVILEGE = "" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1002000300" (CHAR)
DEFINE _EDITOR = "vi" (CHAR)
DEFINE _O_VERSION = "Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options" (CHAR)
DEFINE _O_RELEASE = "1002000300" (CHAR)
SQL>
   ͨ¹ýset sqlprompt ÃüÁ¿ÉÒÔÐÞ¸ÄÏÖʵµÄÄÚÈÝ£¬ ±ÈÈçÏñÏÂÃæÕâÑù£º
SQL> set sqlprompt '_USER _DATE > '
HMSIMIS 09-MAY-10 >
   ÕâÀïʹÓÃÁËÁ½¸öoracleÒѾ­¶¨ÒåµÄ±äÁ¿À´¶¨ÒåÏÔʾµÄÄÚÈÝ£¬¿ÉÒÔ¿´µ½Ä¿µÄÒѾ­µ½£¬Èç¹ûoracleÕÒ²»µ½ÔÚdefinedÖж¨ÒåµÄÔòÔ­ÑùÊä³ö£¬±ÈÈç“>”Ô­ÑùÊä³öÁË¡£
   Èç¹ûÎÒÃÇÏëÏÔʾµÄÄÚÈÝÔÚÒÔÉÏdefineÖÐûÓж¨ÒåÔõô°ì£¿»¹ÊÇÓа취µÄ£¬Í¨¹ý¹¹ÔìÎÒÃǵÄÐÅÏ¢ÈÃÆäÏÔʾ£¬±ÈÈçÏÂÃæÕâÑù:
HMSIMIS 09-MAY-10 > column session_info new_value sql_prompt
HMSIMIS 09-MAY-10 > select '('||SID||','||serial#||','||')' session_info from v$session where username='HMSIMIS' and status='ACTIVE';
SESSION_INFO
------------------------------------------------------------------------------------
(957,6312,)
HMSIMIS 09-MAY-10 > set sqlprompt 'sql_prompt >';
(957,6312,) >
      ÕâÑùÒ»À´ÏëÏÔʾÈκζ«Î÷¶¼²»³ÉÎÊÌâÁË£¬ÊDz»ÊǺÜÓÐÒâ˼£¡


Ïà¹ØÎĵµ£º

Java³ÌÐòÁ¬½ÓSQL Server

µÚÒ»£ºÒªÉèÖÃSQL ServerµÄTCP/IP·þÎñ
1) ´ò¿ªSQL Server Configuration Manager”,Ë«»÷“SQL Server 2005ÍøÂçÅäÖÔ£¬µã»÷“*** µÄЭÒé” (×¢Ò⣺***´ú±íʵÀýÃüÃû£¬ÀýÈ磺accpDBµÄЭÒé)
2) Ñ¡ÔñÓұߴ°¿ÚÖеēTCP/IP”ЭÒ飬ÓÒ¼üµ ......

sql ÓαêµÄʹÓÃ

Ò»¸öÀý×Ó£º´Ótszl±íÖвé³öÊý¾Ý£¬¸ù¾Ýcs×ֶεÄÖµ¾ö¶¨ÍùBOOK_SERIAL±íÖвåÈ뼸ÐÐÊý¾Ý¡£
declare @num int
declare @id varchar(60)
declare @classbm varchar(60)
set @classBm='101'
declare id cursor for select id,cs from  [tszl]
open id
fetch next from id into @id,@num
while @@fetch_status!=-1
&nb ......

PowerDesignerÉú³ÉsqlºÍ·´Ïò¹¤³ÌÉú³ÉERͼµÄÎÊÌâ

PowerDesignerÉú³ÉsqlºÍ·´Ïò¹¤³ÌÉú³ÉERͼµÄÎÊÌâ
Ò»¡¢PowerDesignerÉú³ÉsqlÎÊÌâ
Éú³ÉsqlµÄ·½·¨ÊÇ Database -->Generate Database (Ctrl + G ) µ«ÊÇÌáʾ
Could not load VBScript engine.
Check VBScript installation.
Generation aborted due to errors detected during the verification of the model.
¼ì²éÁ˺à ......

C#Á¬½ÓAccessºÍSQL ServerÊý¾Ý¿â

C#Á¬½ÓÁ¬½ÓAccess
Ê×ÏÈ¿´Ò»¸öÀý×Ó´úÂëÆ¬¶Ï:
³ÌÐò´úÂë:
--------------------------------------------------------------------------------
using System.Data;
using System.Data.OleDb;
......
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=C:\BegASPNET\Northwin ......

¼¸¸öɾ³ýÖØ¸´¼Ç¼µÄSQLÓï¾ä

±ÈÈçÏÖÔÚÓÐÒ»ÈËÔ±±í  £¨±íÃû£ºpeosons£©
ÈôÏ뽫ÐÕÃû¡¢Éí·ÝÖ¤ºÅ¡¢×¡Ö·ÕâÈý¸ö×Ö¶ÎÍêÈ«ÏàͬµÄ¼Ç¼²éѯ³öÀ´
select   p1.*   from   persons   p1,persons   p2   where   p1.id<>p2.id   and   p1.cardid &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ