Cov txheej txheem:

Kuv yuav tsim DDL tsab ntawv hauv Oracle SQL Developer li cas?
Kuv yuav tsim DDL tsab ntawv hauv Oracle SQL Developer li cas?

Video: Kuv yuav tsim DDL tsab ntawv hauv Oracle SQL Developer li cas?

Video: Kuv yuav tsim DDL tsab ntawv hauv Oracle SQL Developer li cas?
Video: Ua lub neej sib hlub, lau lawm lo tseem hau chawv 2 2024, Kaum ib hlis
Anonim

Txhawm rau tsim DDL nqe lus:

  1. Ntawm nplooj ntawv chaw ua haujlwm, nyem qhov SQL ntawv Rhiav.
  2. Nyem Utilities.
  3. Nyem Tsim DDL . Cov Tsim DDL nplooj tshwm.
  4. Nyem Tsim tsab ntawv . Cov Tsim DDL Wizard tshwm.
  5. Xaiv ib tug database schema thiab nyem Next.
  6. Txhais hom khoom:
  7. Nyem Tsim DDL .

Tsis tas li ntawd, kuv yuav tsim ib tsab ntawv hauv Oracle SQL Developer li cas?

Txhawm rau tsim ib tsab ntawv SQL hauv Script Editor:

  1. Ntawm nplooj ntawv chaw ua haujlwm, nyem SQL Rhiav thiab tom qab ntawd SQL Scripts.
  2. Nyem qhov Tsim khawm.
  3. Sau ib lub npe rau tsab ntawv hauv Script Name field.
  4. Nkag mus rau SQL nqe lus, PL / SQL blocks thiab SQL * Ntxiv cov lus txib koj xav kom suav nrog hauv koj tsab ntawv.

Kuj Paub, Kuv yuav ua li cas khiav DDL tsab ntawv hauv Oracle?

  1. Kauj Ruam 1: Npaj koj DDL ua ntej.
  2. Kauj ruam 2: Khiav koj DDL los ntawm PL / SQL program siv Execute tam sim.
  3. Ua ntej: Ib txwm kaw koj cov lus SQL rau hauv ib khub ntawm Ib Leeg Quotes.
  4. Thib ob: Saib xyuas Semi-colon.

Qhov thib ob, kuv yuav saib cov ntawv hauv SQL Developer li cas?

Kuv pom tias kuv tuaj yeem nias SHIFT + F4 rau ib qho saib hauv SQL Developer thiab tau cov tsab ntawv ntawm saib hauv Details Tab.

Kuv yuav ua li cas khiav ib. SQL cov ntaub ntawv hauv Oracle?

Khiav ib tsab ntawv li koj pib SQL*Plus

  1. Ua raws li SQLPLUS hais kom ua nrog koj tus neeg siv lub npe, ntu ntu, qhov chaw, @, thiab lub npe ntawm cov ntaub ntawv: SQLPLUS HR @SALES. SQL*Plus pib, prompts rau koj lo lus zais thiab sau tsab ntawv.
  2. suav nrog koj lub npe siv raws li thawj kab ntawm cov ntaub ntawv. Ua raws li SQLPLUS hais kom ua nrog @ thiab lub npe file.

Pom zoo: