Cov txheej txheem:

How do I show DBMS<UNK>output in SQL Developer?
How do I show DBMS<UNK>output in SQL Developer?

Video: How do I show DBMS<UNK>output in SQL Developer?

Video: How do I show DBMS<UNK>output in SQL Developer?
Video: How to Enable DBMS_OUTPUT in SQL Developer | Oracle SQL Developer Tips and Tricks 2024, Tej zaum
Anonim

Yog li, hauv cov ntsiab lus, txhawm rau pab kom SQL Developer DBMS_OUTPUT:

  1. Qhia DBMS_OUTPUT vaj huam sib luag los ntawm kev mus saib > DBMS Output.
  2. Nyem qhov ntsuab + cim kom pab nws rau qhov kev sib txuas no.
  3. Xyuas kom tseeb tias koj muaj DBMS_OUTPUT nqe lus hauv koj qhov chaws qhov chaw, thiab ua tiav cov cai ntawd.

Tib neeg kuj nug, Kuv yuav ua li cas thiaj pom cov lus nug tawm hauv SQL Developer?

  1. Qhib Oracle Developer.
  2. Nyem "Saib" thiab tom qab ntawd nyem "Dbms Output."
  3. Nyem qhov ntsuab "+" kos npe rau hauv lub qhov rais uas qhib thiab xaiv cov ntaub ntawv sib txuas los ntawm qhov koj xav tau cov zis. Cov zis tam sim no yuav tshwm sim rau cov ntaub ntawv ntawd hauv lub tab tshiab.

Qhov thib ob, Kuv yuav ua li cas kho SQL Developer? Customizing SQL Developer Toolbars

  1. Nyem, nyem, nyem… Tam sim no koj yuav tau txais lub qhov rais popup.
  2. Koj tseem tuaj yeem luag thiab poob toolbar nyees khawm kom rov xaj lawv ntawm lub toolbar. Koj tuaj yeem hloov kho qhov Debugger toolbar, tsuas yog pib qhov kev sib tham debug ua ntej.
  3. Kuv yeej tsis siv 'Suspend All Breakpoints Button', yog li kuv yuav tshem nws.

Tsis tas li ntawd, kuv yuav saib cov kab lus hauv SQL Developer li cas?

Mus saib cov ntaub ntawv rooj:

  1. Hauv SQL Developer, nrhiav ib lub rooj raws li tau piav qhia hauv "Saib Tables".
  2. Xaiv lub rooj uas muaj cov ntaub ntawv.
  3. Hauv cov khoom pane, nyem qhov Data subtab.
  4. (Yeem) Nyem ib kab npe los txheeb cov ntaub ntawv los ntawm kab ntawv ntawd.
  5. (Yeem) Nyem rau SQL subtab kom pom SQL nqe lus uas txhais lub rooj.

Kuv yuav rov txuas dua hauv SQL Developer li cas?

Configure Oracle SQL Developer Cloud Connection

  1. Khiav Oracle SQL Developer hauv zos. Oracle SQL Developer home page qhia.
  2. Nyob rau hauv kev sib txuas, txoj nyem Connections.
  3. Xaiv Kev Txuas Tshiab.
  4. Ntawm New/Select Database Connection Dialog, ua cov lus hauv qab no:
  5. Nyem Test.
  6. Nyem Txuas.
  7. Qhib qhov txuas tshiab.

Pom zoo: