官术网_书友最值得收藏!

  • Oracle SQL Developer
  • Ajith Narayanan
  • 196字
  • 2021-07-16 09:39:04

Creating new database objects

In the first section of the chapter, we looked at browsing objects and data in the database. You may, if you are an application developer and working with a completed database design, spend most of your time doing just that. It is more likely, though, that you'll need to make changes such as adding or modifying structures and data. SQL Developer provides the dialogs to assist you.

In the same way that you can write SQL queries to extract information about the objects you have access to, you can write the SQL Data Definition Language (DDL) to create, edit, and modify these objects. Almost all of the object nodes in the Connections navigator provide a context menu to create a new object. To invoke a dialog that creates any new object, select the object in the navigator and invoke the context menu.

The following list is an exception for creating new objects using context menus:

  • Editioning Views
  • Queues
  • Queue Tables
  • Cross Edition Triggers
  • Directories
  • Editions
  • Application Express
  • XML DB Repository
  • Recycle Bin

A right-click on the previously listed objects nodes under Connections navigator will not provide us with the Create New option.

主站蜘蛛池模板: 云和县| 聂荣县| 逊克县| 若尔盖县| 荔波县| 济源市| 香格里拉县| 大庆市| 凭祥市| 察隅县| 景泰县| 漯河市| 龙游县| 罗源县| 新绛县| 南澳县| 海南省| 马山县| 永安市| 永吉县| 卫辉市| 赣州市| 灌阳县| 璧山县| 长武县| 黎城县| 襄汾县| 福贡县| 禄劝| 博爱县| 浮梁县| 石家庄市| 仪征市| 鄂尔多斯市| 孟州市| 彰化市| 类乌齐县| 涡阳县| 丽江市| 德令哈市| 镇远县|