文章分类 -  SQL基本

摘要：Oracle8 select a.*,b.* from a,b where a.id(+)=b.id --相当于左联接 select a.*,b.* from a,b where a.id=b.id(+) --相当于右联接 Oracle9 支持以上的写法，还增加了LeftJoin、Right Join等 select a.*,b.* from a left join b on a.id=b.i... 阅读全文

摘要：SELECT * FROM CustomersDELETE FROM Customers WHERE PKId=1UPDATE Customers SET UserID='sq' WHERE PKId=1INSERT INTO Customers(UserID,TrueName) VALUES ('shiqiang','宝剑') 在oracle8.05中设置访问数据库别名：WSTXNY.WOR... 阅读全文