ͼƬ¶þ½øÖÆ´æÈëORACLEºÍд³ö
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.IO;
using System.Data.OracleClient;
public partial class _Default : System.Web.UI.Page
{
WebService web = new WebService();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridView1.DataSource = web.UpLoad();
GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Stream imgdatastream = FileUpload1.PostedFile.InputStream;
int imgleng = FileUpload1.PostedFile.ContentLength;
string name = FileUpload1.FileName;
byte[] imgdata = new byte[imgleng];
if (web.UP(name,imgdata,imgleng))
{
GridView1.DataSource = web.UpLoad();
GridView1.DataBind();
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
LinkButton linkbtn = sender as LinkButton;
Ïà¹ØÎĵµ£º
·ÖÒ³µÄ×ÚÖ¼ÊÇ¿ØÖƲéѯ³öÀ´µÄÊý¾Ý¸öÊý£¬ÏÂÃæÕâÌõÓï¾ä¶ÔÓÚOracle·ÖÒ³ÒѾ×ã¹»ÁË¡£
£¨×¢£º¸ÃÓï¾äÖ»ÄÜÓÃÓÚOracle£©
SELECT * from (SELECT temp.*, ROWNUM RN from (SELECT * from USERS ORDER BY ID DESC) temp) WHERE RN > 0 AND RN <= 10
SELECT *
from (SELECT AA.*, ROWNUM RN ......
1.ÔÚORACLEÖÐÓÃselect * from all_usersÏÔʾËùÓеÄÓû§£¬¶øÔÚMYSQLÖÐÏÔʾËùÓÐÊý¾Ý¿âµÄÃüÁîÊÇshow databases¡£¶ÔÓÚÎÒµÄÀí½â£¬ORACLEÏîÄ¿À´ËµÒ»¸öÏîÄ¿¾ÍÓ¦¸ÃÓÐÒ»¸öÓû§ºÍÆä¶ÔÓ¦µÄ±í¿Õ¼ä£¬¶øMYSQLÏîÄ¿ÖÐÒ²Ó¦¸ÃÓиöÓû§ºÍÒ»¸ö¿â¡£ÔÚORACLE(db2Ò²Ò»Ñù)Öбí¿Õ¼äÊÇÎļþϵͳÖеÄÎïÀíÈÝÆ÷µÄÂß¼±íʾ£¬ÊÓͼ¡¢´¥·¢Æ÷ºÍ´æ´¢¹ý³ÌÒ² ......
[×ÊÁÏÀ´×ÔÓÚORACLEƵµÀ http://oracle.chinaitlab.com/induction/398193.html]
¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
¡¡¡¡ÀýÈç:
¡¡¡¡SELECT /*+ALL_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='SCOTT';
¡¡¡ ......
ora-38301´íÎó,»ØÊÕÕ¾
ǰ¼¸ÌìÓÐͬʸæËßÎÒ£¬ÓÐ̨·þÎñÆ÷Éϵıí¿Õ¼äÎÞ·¨É¾³ý£¬ÈÃÎÒ¿´¿´¡£µÇ¼µ½·þÎñÆ÷£¬É¾³ý±í¿Õ¼ä£¬Êý¾Ý¿âͬʱ±¨ora-00604ºÍora-38301´íÎ󡣯ð³õÒÔΪÊÇÓÐÊý¾Ý¿â¶ÔÏó±»Ëø¶¨£¬ÖØÆôÊý¾Ý¿âºó£¬·¢ÏÖ»¹ÊDZ¨Í¬ÑùµÄ´íÎó¡£Googleºó·¢ÏÖ¿ÉÄÜÓë10gµÄÒ»¸öÐÂÌØÐÔ»ØÊÕÕ¾Óйأ¬Çå¿Õ»ØÊÕÕ¾purge recyclebinºó£¬½øÐÐɾ³ý»¹ÊDZ ......
1¡¢°²×°
2¡¢´´½¨“±¾µØNet·þÎñÃû”
3¡¢PLSQL Developer Á¬½Ó²âÊÔ
4¡¢´´½¨±í¿Õ¼ä
1.´ò¿ªsqlplus¹¤¾ß£º
sqlplus /nolog
2. Á¬½ÓÊý¾Ý¿â£º
conn /as sysdba
3. ´´½¨±í¿Õ¼ä£º
create tablespace camds datafile 'D:\oracle\product\10.2.0\oradata\camds\camds.dbf' size  ......