Re: Sql กะ Oracle คืออะไร???

[kross]

Oracle และ SQL คืออันหยัง ???
SQL = structrure qurey language (อ่านกันว่า ซีควอล นะ มะใช่ เอส - คิว - แอล)

จัดเป็นภาษาในยุคที่4 ที่ออกแบบมาให้ใช้งานได้ง่าย กว่า ยุคที่3 อย่าง C,C++,Pascal, บลาๆๆๆๆ ที่ถูกสร้างมาเพื่อ โปรแกรมเมอร์โดยเฉพาะ แต่ ซีควอล จะสารมารถจัดการฐานข้อมูลได้ด้วยตัวเอง ด้วยรูปแบบ ไวยากรณ์ ภาษา Eng

เช่น " select S_Name(เลือก ชื่อ) from IT_Student(จาก ชื่อแฟ้มงาน) where S_Number = 'S330'(ที่มี รหัส S330)
จากคำสั่งข้างต้นจะ เป้น command แบบง่ายๆในการค้นหาข้อมูล ซึ่งในที่นี้ก้ได้แต่นายโครแว็กซซซ

ส่วน oracle นั้น คือ โปรแกรมสร้างฐานข้อมูล ต่างๆที่สร้างจากรูปแบบคำสั่งของ ภาษา sql ขึ้นมา โดยอาจเปรียบได้กลับ sql เหมือน ภาษา Html และ oracle คือ โปรแกรม Dreamweaver ที่ช่วยให้สร้างฐานข้อมูลได้โดยง่ายขึ้นหละ

ต่อไป คำสั่ง 5ประเภท ของsql

[Crovax]

ดีๆ ว่าแต่มี Oracle ปะ
อยากได้ SQL ด้วยเลยก็ดี

[newsbot]

Ton of Oracle ebook can be found here:

http://www.flazx.com/category61.php


Advanced SQL Functions in Oracle 10g
Designed to exploit Oracle 10g's SQL, this book is a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions...

Cost-Based Oracle Fundamentals (Expert's Voice in Oracle)
The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums...

Developing Personal Oracle7 for Windows 95 Applications
If you want to develop practical, productive applications using Personal Oracle7 for Windows 95, this hands-on tutorial is for you...

Expert One-on-One Oracle
Tom Kyte is of a rare breed...

Expert Oracle Database 10g Administration (Expert's Voice)
This is a unique, one-volume guide to the administration and management of the Oracle database...

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions
This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications...

Mastering Oracle SQL
Few books on the market today go beyond discussing syntax and the barest rudiments of using Oracle SQL...

Object-Oriented Oracle

The popularity of object-oriented concepts, design, and programming has stimulated the need for a database system that enables a straightforward process to store and retrieve object instances...

Oracle 10g Data Warehousing
Oracle Oracle Database 10g...

Oracle 9iAS Portal Bible
Oracle databases have long handled the publicly invisible task of managing large corporate data stores...

Oracle Application Server 10g Administration Handbook (Osborne ORACLE Press Series)
From the exclusive publisher of Oracle Press books, here is an architectural and technical reference on how to use Oracle Application Server 10g to Web-enable Oracle databases for application server systems...

Oracle Built in Packages
Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications...

Oracle Database 10g Insider Solutions
Oracle Database 10g Insider Solutions is a must-have reference guide for all Oracle professionals...

Oracle Database 10g: A Beginner's Guide (Osborne ORACLE Press Series)
Bookwatch : Two new Oracle instruction and resource titles from Osborne/McGraw-Hill are indispensable additions to personal and professional reference collections...

Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)
Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press...

Oracle Database Foundation


Oracle Database Foundations : Technology Fundamentals for IT Success
The world of IT is always evolving, but in every area there are stable, core concepts that anyone just setting out needed to know last year, needs to know this year, and will still need to know next year...

Oracle DBA Guide to Data Warehousing and Star Schemas
Oracle DBA Guide to Data Warehousing and Star Schemas...

Oracle High Performance Tuning for 9i and 10g, First Edition
There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration...

Oracle PL/SQL Built-ins Pocket Reference
This pocket reference provides quick-reference information that will help you use Oracle Corporation's extensive set of built-in functions and packages, including those new to Oracle8...

Oracle PL/SQL for DBAs
PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years...

Oracle Real Application Clusters
Clustered configuration first hit the scene nearly 20 years ago when Digital Equipment Corporation (DEC) introduced the VaxCluster...

Oracle Security
Security in a relational database management system is complex, and too few DBAs, system administrators, managers, and developers understand how Oracle implements system and database security...

Oracle SQL, First Edition : Jumpstart with Examples
Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks...

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
Identify and Resolve System Bottlenecks Quickly Troubleshoot, diagnose, and optimize your Oracle database efficiently and successfully every time...

Oracle9i DBA JumpStart
Interested in a career as an Oracle database professional but don't know where to begin? The Oracle9i OCA and OCP certifications are two of the hottest IT certifications around, and the Oracle9i DBA JumpStart from Sybex can provide you with the solid foundation in database administration and programming basics you'll need before embarking on a comprehensive study program...

Oracle9i: The Complete Reference
Master all the powerful features of Oracle9 i using the exclusive information inside this indispensable resource...

Perl for Oracle DBAs
Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle9i, Oracle8i, and earlier databases...

Professional Oracle Programming (Programmer to Programmer)

One of the only Oracle books to focus exclusively on database programming rather than administration
Oracle owns sixty percent of the commercial database market
Provides full coverage of the latest Oracle version, 10g-including new features such as regular expressions and the MODEL SQL clause-as well as versions 8, 8i, and 9i
The authors are well-known as Oracle gurus-Greenwald is the author of Oracle in a Nutshell and the coauthor, with Stackowiak, of Oracle 9 Essentials
Shows how to use Oracle data and data structures to build robust, scalable database applications using Java, SQL, and PL/SQL


TOAD Handbook
TOAD Handbook is a guide for developing Oracle applications and administering Oracle databases with TOAD...

[fowl]

กะลังเรียน oracle อยู่พอดี