- Oracle Database XE 11gR2 Jump Start Guide
- Asif Momen
- 136字
- 2021-08-13 18:28:13
Chapter 4. Accessing Table Data, DML Statements, and Transactions
Always desire to learn something useful. - Sophocles
In this chapter, we will install Oracle's free graphical tool, SQL Developer and use it to communicate with Oracle Database XE. You use SQL Developer to browse database objects and execute SQL statements. Querying the database is the most common job and this chapter focuses on writing simple and multi-table queries. We will also see some of the common database functions that are used in a daily routine. The following are the topics that are covered in this chapter:
- Unlocking sample user accounts
- Installing SQL Developer
- Connecting SQL Developer to Oracle Database 11g XE
- About TAB and DUAL
- Writing simple queries
- Selecting data from multiple tables
- Exploring common functions
- What are Transaction Control Statements?
- Commit Understanding DML statements
推薦閱讀
- React Native Cookbook
- Java應(yīng)用開發(fā)與實(shí)踐
- OpenStack Cloud Computing Cookbook（Fourth Edition）
- Windows內(nèi)核編程
- Terraform：多云、混合云環(huán)境下實(shí)現(xiàn)基礎(chǔ)設(shè)施即代碼（第2版）
- Python語言實(shí)用教程
- “笨辦法”學(xué)C語言
- 遠(yuǎn)方：兩位持續(xù)創(chuàng)業(yè)者的點(diǎn)滴思考
- JavaScript從入門到精通（視頻實(shí)戰(zhàn)版）
- Unity Android Game Development by Example Beginner's Guide
- Python一行流：像專家一樣寫代碼
- Modular Programming with JavaScript
- 信息學(xué)奧林匹克競賽初賽精講精練
- MonoTouch應(yīng)用開發(fā)實(shí)踐指南：使用C#和.NET開發(fā)iOS應(yīng)用
- ROS Robotics Projects