通过错误的sql来测试推理sql的解析过程.pdf

sqlsql SQL • 1.sql from,select 2.sql 3. select3*3from3t3t hr.test 4. 5. 6.sqllibrary3 cacheheap • create3table3test3(id3number,name varchar2(30)); • select13id13from23test13where33id1=‘aaa’3 group3by43id13order by53id1; • select from,where,group by,order by select • • select3id13from3test13where33id1=‘aaa’3 group3 by43id13order by53id1; • id1where3, • • where • select3id13from3test13where3id1=‘aaa’3group3 by43id13order by53id1; • group3by • • • select3id13from3test13where3id1=aaa3group3by3 id13order by3id1; • test1, • • • select3id13from3test3where3id1=aaa3group3by3 id13order33by3id1; • group3by3 • select,where,order by • select3id13from3test3where3id1=aaa3group3by3 id3order33by3id1; • where3 • select,order by • select3id13from3test3where3id1=aaa3group3by3 id3order33by3id1; • select3id13from3test3where3id=aaa3group3by3id3 order3by3id1; • select3id3from3test3where3id=aaa3group3by3id3 order by3id1; • order3by • select3id3from3test3where3id=aaa3group3by3id3 order33by3id;3 • no3rows3selected • Insert3into3test3values(1,’aaa’); • select3id3from3test3where3id=aaa3group3by3id3 order by3id;