³£ÓÃSQLÓï¾ä£¨Oracle£©(ת)
ORACLEÖÐ×ֶεÄÊý¾ÝÀàÐÍ
×Ö·ûÐÍ char ·¶Î§ ×î´ó2000¸ö×Ö½Ú ¶¨³¤
char(10) 'ÕÅÈý' ºóÌí¿Õ¸ñ6¸ö°Ñ10¸ö×Ö½Ú²¹Âú 'ÕÅÈý '
ÐÔ±ð char(2) 'ÄÐ'
varchar2 ·¶Î§ ×î´ó4000¸ö×Ö½Ú ±ä³¤
varchar2(10) 'ÕÅÈý' ÔÚÊý¾Ý¿âÖÐ'ÕÅÈý'
´ó¶ÔÏó ×Ö·ûÐÍ´ó¶ÔÏó >4000×Ö½Ú ×î´ó4G
CLOB (Character Large OBject)
Êý×Ö number ·¶Î§ 10µÄ-38´Î·½ µ½10µÄ38´Î·½
¿ÉÒÔ±íʾСÊý Ò²¿ÉÒÔ±íʾÕûÊý
number(4) ×î´ó±íʾ4λÕûÊý -9999 µ½ 9999
number(5,2) ±íʾ5λÓÐЧÊý×Ö 2λСÊýµÄ Ò»¸öСÊý -999.99 µ½ 999.99
Ïà¹ØÎĵµ£º
As a response for customer's question, I decided to write about using Like Operator in Linq to SQL queries.
Starting from a simple query from Northwind Database;
var query = from c in ctx.Customers
where c.City == "London"
&nbs ......
1ʹÓò»´ø²ÎÊýµÄ´æ´¢¹ý³Ì
¡¡¡¡Ê¹Óà JDBC Çý¶¯³ÌÐòµ÷Óò»´ø²ÎÊýµÄ´æ´¢¹ý³Ìʱ£¬±ØÐëʹÓà call SQL תÒåÐòÁС£²»´ø²ÎÊýµÄ call תÒåÐòÁеÄÓï·¨ÈçÏÂËùʾ£º
¡¡¡¡
ÒÔÏÂÊÇÒýÓÃÆ¬¶Î£º
{call procedure-name}
¡¡¡¡×÷ΪʵÀý£¬ÔÚ SQL Server 2005 AdventureWorks ʾÀýÊý¾Ý¿âÖд´½¨ÒÔÏ´洢¹ý³Ì£º
¡¡¡¡
ÒÔÏÂÊÇÒýÓÃÆ¬¶Î£º
......
1.
select top m * from tablename where id not in (select top n id from tablename)
2.
select top & ......
ÔÚ Oracle 10g ÖÐ
¿ÉÒÔͨ¹ý http://localhost:5560/isqlplus ·ÃÎÊ isqlplus
ÔÚ isqlplus ÖÐ ¿ÉÒÔÖ´ÐÐ plsql
set serveroutput on size 100000 // ´ò¿ª ·þÎñÆ÷µÄÊä³ö on ºóÃæÊÇ »º´æµÄ´óС ·¶Î§ÊÇ (2000 ÖÁ 1000000)
begin
dbms_output.put_line('hel ......
1¡¢°´Ê±¼äÅÅÐò
select * from tbl_lms_loginhistory order by loginhistory_logintime desc
2¡¢
ÔÚÒ»¸öÊý¾Ý¿âÖÐÊÇÏÂÁеÄÑù×Ó
³µ´Î Éí·ÝÖ¤ºÅ
27 1
27 2
45 1
25 1
45 2
ÏÖÔÚÎÒÏë »ñµÃµÄÊÇ
³µ´Î ³Ë×ø´ÎÊý
25 1
27 3
45 2
ÇëÎÊ£¬ÎÒµÄSQLÓï¾ä¸ÃÔõôд£¿
select ³µ´ ......