С²¼×÷Æ·£ºOracle 11g SQL»ù´¡ÈëÃÅϵÁÐÅàѵ(È«30½²)
==============================================
µÚ01½²: Chapter 00--Oracle 11g SQL Fundamentals Training Introduction
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2003
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2003.zip
µÚ02½²: Chapter 00--Oracle 11g SQL Fundamentals Training Introduction
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2004
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2004.zip
µÚ03½²: Chapter 01--Restricting Data Using the SQL SELECT Statement
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2005
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2005.zip
µÚ04½²: Chapter 01--Restricting Data Using the SQL SELECT Statement
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2006
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2006.zip
µÚ05½²: Chapter 02--Restricting and Sorting Data
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2008
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2008.zip
µÚ06½²: Chapter 02--Restricting and Sorting Data
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2009
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2009.zip
µÚ07½²: Chapter 02--Restricting and Sorting Data
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2021
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2021.zip
µÚ08½²: Chapter 03--Using Single-Row Functions to Customize Output
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2022
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2022.zip
µÚ09½²: Chapter 03--Using Single-Row Functions to Customize Output
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2023
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2023.zip
µÚ10½²: Chapter 04--Using Conversion Functions and conditional Expressions
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2024
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2024.zip
µÚ11½²: Chapter 04--Using Conversion Functions and conditional Expressions
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2025
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk2025.zip
µÚ12½²: Chapter 05--Reporting Aggregated Data Using the Group Functions
ÔÚÏß¹Û¿
Ïà¹ØÎĵµ£º
1.˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ,Ô´±íÃû£ºa бíÃû£ºb)
SQL: select * into b from a where 11
2.˵Ã÷£º¿½±´±í(¿½±´Êý¾Ý,Ô´±íÃû£ºa Ä¿±ê±íÃû£ºb)
SQL: insert into b(a, b, c) select d,e,f from a;
3.˵Ã÷£ºÏÔʾÎÄÕ¡¢Ìá½»È˺Í×îºó»Ø¸´Ê±¼ä
SQL: select a.title,a.username,b.adddate from table a,(select max(adddat ......
SQLµ±Ç°ÈÕÆÚ»ñÈ¡¼¼ÇÉ
select getdate() //2003-11-07 17:21:08.597
select convert(varchar(10), getdate(),120) //2003-11-07
select convert(char(8),getdate(),112)  ......
½¨±í£º
CREATE TABLE [DB.dbo].tableName
(Stud_id int CONSTRAINT constraintName1 not null primary key,
Name nvarchar(5) not null,
Birthday datetime,
Gender nchar(1),
Telcode char(12),
Zipcode char(6) CONSTRAINT constraintName2 CHECK(zipcode like [ ......
¶ÔÓÚsqlÖеĺ¯Êý¿ÉνÊǶàµÄ²»Ê¤Ã¶¾Ù£¬±¾ÎÄ´Ó³£Óú¯ÊýµÄ½Ç¶È¶ÔÆ亯Êý½øÐÐ×ܽ᣺1¡¢ÈÕÆÚºÍʱ¼äº¯Êý2¡¢×Ö·û´®º¯Êý3¡¢ÏµÍ³º¯ÊýÁ÷³Ì¿ØÖÆÓï¾ä
1¡¢ ÈÕÆÚºÍʱ¼äº¯Êý
¶ÔÓÚÈÕÆÚº¯ÊýÎÒÃÇ¿ÉÒÔ·ÖΪ2СÀà½øÐзÖÎö´¦Àí£¬
A¡¢ ÈÕÆÚµÄÕûÌå´¦Àíº¯Êý£¬¾ßÌåµÄº¬ÒåºÍÓï·¨ÈçÏÂËùʾ£º
DATEADD(datepart,number,date)
µÚÒ»¸ö²ÎÊý˵Ã÷ÒªÌí ......
==============================================
µÚ1½²
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk1389
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk1389.zip
µÚ2½²
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk1390
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk1390.zip
µÚ3½²
ÔÚÏß¹Û¿´£º http ......