oracle pl sql questions

Tags: des C Class A HTTP tarAlways use SQL Develope connection database, as long as the write on IP, user name, password, sid and so on can connect, and later found that using PL/SQL connection to the remote Oracle database How to connect ah?Here's how to modify the Oracle c

The permission control in win7 is indeed good, but sometimes it is hard to understand. Today, an Oracle database is installed on an XP Server, and an Oracle client is installed on my win7 server. The configuration is successful, but PL/SQL cannot be connected to the database when it is started, and no prompt is display

Declare partial logic part other exception handling part; PL/SQL block syntax Common Oracle Exception Handling Name Description Other Including all exceptions (maximum exceptions) Value_error Value exception No_data_found No data found Too_many_rows Too much data

modify the code yourself, automatically generated code is enough. Parameters are required to enter parameter values in the following parameter input table.4, start debugging. Click the Start icon on the toolbar or press F9 to enter debug mode, the subsequent debugging process is the same as we are familiar with the debugging process (the following is a menu or a section of the tool bar debugging function):Run (CTRL+R) runs at full speed and stops at the breakpoint;Step Into (CTRL + N) performs

exception (this is the choice of custom exceptions in most cases); if it is TRUE, the newly thrown exceptions are stored at the top of the exception stack (Other exceptions have occurred ).3) Oracle pre-defined PL/SQL exceptions Exception name ORACODE SQLCODE Trigger time LOGIN_DENIED 01017 -1017 Invalid user name or password

First install Oracle Enterprise Edition or client lite. After that, you need to modify your Tnsnames.ora file to increase the database.My Oracle instance is ORACLE1 and placed in the D:\oracle\ directory. My IP address is 192.168.1.102.Modify the following: add: DEMO = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.102) (PORT = 1521)) (Connect_data

Oracle Database Programming: PL/SQL programming basics Oracle Database Programming: basic concepts of Oracle databases http://www.bkjia.com/database/201307/226254.html 2. PL/SQL program

The following is a detailed analysis of the if statement in Oracle PLSQL. For more information, see copy the code below: * If statement: determine the number entered by the user. * Setserveroutputon -- input acceptnumprompt on the receiving keyboard. Enter a number:; declare -- enter the number entered on the screen. The following is a detailed analysis of the if statement in PL/

1. Download PL/SQL Dev 2. Download the simplified Oracle client 3. Install PL/SQL Dev and the Chinese package 4. decompress the Oracle thin client. For example, extract the Directory D: \ oracle10g. 5. Configure the

Oracle 64-bit PL/SQL connection error Make sure you have the 32 B... oracle OraDb11g_home 64-bit under Windows 64-bit server. PLSQL Developer has the following problems: 1. The Database drop-down box is blank. 2. Enter the user name, password, and Database. The logon prompt is displayed: initialation error cocould not

Oracle beginners, start oracle service on Windows: net start OracleServiceOrcl, and then open pl/SQL to connect to oracle, but an error is displayed, cannot connect. Later I found that the listening service was not started, so I started the listening service: Net start Oracl

20-feb-81 1600 300 307521 WARD salesman 7698 22-feb-81 1250 500 307654 MARTIN salesman 7698 28-sep-81 1250 1400 307698 BLAKE MANAGER 7839 01-may-81 2850 307844 TURNER salesman 7698 08-sep-81 1500 0 307900 JAMES Clerk 7698 03-dec-81 950 306 rows selected.Define and UndefineSql> Define Name=enameSql> select name,sal from emp;Ename SAL---------- -----SMITH 800ALLEN 1600WARD 1250JONES 2975MARTIN 1250BLAKE 2850CLARK 2450SCOTT 3000KING 5000TURNER 1500ADAMS 1100JAMES 950FORD 3000MILLER 1300Rows select

------------------------------------------------------------------------0 | --> 1871 |> 512 |> 343 |> 194 |> 195 |> 206 |> 507 |-> 107NOW: 8 | ---------> 6829 | -----------------> 134210 | ------------------------> 185411 | -----------------> 129212 | ------------------> 141613 | ---------------> 118014 | ----------------> 121715 | --------------------> 157316 | -----------------------> 178517 | -------------------> 146918 | -------------------------> 189219 | -------------------------> 190720 |

Features of automatic PL/SQL running in Oracle: Run the automatic scheduling task in the UNIXDE corn Utility You can use the DBMS_JOB package in PL/SQL in ORACLE to schedule PL/

dual;F1 ()----------59788330Used time: 00:00:07.09 -can see the data change, even if not using relies_on, the result set is also correct. Sql> Select COUNT (*)From Test1, test2where Test1.object_type = Test2.object_typeand Test1.object_type in (' Table subpartition ', ' VIEW ', ' INDEX ', ' table ');COUNT (*)----------59788330Time used: 00:00:03.56 sql> Create or Replace function F2return numberResult_cac

ORACLE: Configure database connection // Database configuration file directoryE: \ oracle \ ora92 \ Network \ admin \ tnsnames. ora (Database name)Fwmsdb =(Description =(Address_list = Server IP Address(Address = (Protocol = TCP) (host = 10.10.6.40) (Port = 1521 )))(CONNECT_DATA =(SERVICE_NAME = oracledb))) II.1. Use the Oracle Net manager tool 1) Open

PL/SQL single-line functions and group functionsA function is a program that has 0 or more parameters and has a return value. Oracle has built a series of functions in SQL, which can be called SQL or PL/

Oracle Database PL/SQL process and function 4) process www.2cto.com 1. basic concept: oracle allows you to create and store compiled PL/SQL programs in the database, including processes, functions, packages, and triggers. We can s

Please refer to:Http://www.cnblogs.com/ymj126/p/3712727.htmlOrhttp://blog.csdn.net/cselmu9/article/details/8070728Oracle 11g Client can be downloaded from the official Oracle website or at the following URL.Http://pan.baidu.com/s/1X9xDkWhat about PL/SQL developer? Heroes can also be google/baidu to the latest version.Http://pan.baidu.com/s/1X9xDkWood elder brothe

Oracle, paging, and stored procedure are combined to create a paging stored procedure using PL/SQL. 1. Declare a referenced cursor [SQL] view plaincopyprint? 01. create or replace package cur_ref_type02. as -- is or as can be used03. type cur_ref is ref cursor;04. end;Create or replace package cur_ref_typeAs -- is or a