oracle database 11g pl sql programming

PL/SQLPL/SQL is a block-structured language that places a set of statements in a block and sends it to the server at once. It is an extended language combined with Oracle process language and Structured Query languageComposition of PL/SQL code blocksDeclare--The markup decla

PL/SQLIt is an efficient transaction processing language and has the following advantages: 1. SupportSQL 2. Support for Object-Oriented Programming 3. better performance and higher efficiency 4. Easy to write 5.OracleHighly integrated 6. Good Security I. PL/SQLVariables and basic data types 1. PL/SQLV

Tags: SQL dmp file inserted in RAC Text Editor decimal importA. PL/SQL Developer tools generally import and export to Oracle in the following 4 ways: 1, Oracle Export Import methodIn this way, export the file format that is imported as. DMP, which is binary, can be cross-pla

When installing the Oracle database's PL/SQL tool, the computer name is the name of the user name that is automatically generated after reloading the system, as a programmer, there is a strong obsessive-compulsive disorder, you want to use their English name as the name of their computer, so the name of the computer changed; Results

PL/SQL Developer Remote connection to Oracle Database I searched many methods online. This is feasible! 1. Configure the server tnsnames. ora file. If oracle is not installed on the local machine, you can copy one (tnsnames. ora file) in the specified directory, because I

taxV_tax_sal:=v_sal*v_tax_rate;--OutputDbms_output.put_line (' Name: ' | | v_ename| | ' Wages ' | | V_sal | | ' Tax: ' | | V_tax_sal);End--Composite Type composite----PL/SQL records a struct similar to a high-level language--Define a plsql record type Emp_record_typeDeclareType Emp_record_type is record (Aname emp.ename%type,salary emp.sal%type,title emp.job%type);--Defines a variable sp_record the type of

= ' sql ';--DeleteDelete from table (select Ss.score from Stuinfo ss where Stuid = 3) twhere t.subname= ' SQL ';The similarities and differences between----variable arrays and nested tables----------------Same point:1, are abstract types2. Can be used as a data type for a column in a table (record and fast table are not data types for columns)Different points:1. The mutable array itself is stored in the or

PL/SQL Connect Oracle Database 1, IntroductionUse PL/SQL to connect to a remote Oracle database without installing an

Log on to PL/SQL Developer, log on to the local database, and check that the Oracle listening service is not started. Right-click to start the listening program and report an error. How can this problem be solved ?, I. Error description When you log on to PL/

Tags: data import test reg Microsoft software question mark condition technology sharingProblem Description:Login PL/SQL, the output of the Chinese caption is displayed as a question mark after executing the statement???? If the condition contains Chinese, there is no data. ? ?? ?If it is not Chinese, you need to modify the registry value as follows:Enter the registry: Win+r, enter regedit, then return, cli

Basic knowledge of oracle Database PL/SQL 1) Overview: the programming language formed by oracle procedural expansion in the standard SQL language is a unique feature of

was a problem here, I gave Scott that dbms_pipe permission, forgot to enter the user, directly with the SYS run, and then quitUsing Scott to run is not, error, and then should be used in the time of SYS to create a pipeline, Scott does not use this. Then I changed another name.But why can't I quit ...DECLARE pipename VARCHAR2 (n): = ' signaler1 '; Result INTEGER: = Dbms_pipe.create_pipe (Pipename); BEGIN dbms_pipe.pack_message (' Stop '); end;/This is the one that stopped, but it's not good. Lo

Label:The seventh chapter is also quite miscellaneous, see not very clear. Although I finished it, I felt that I had not got too many things and had to go back to see them. See this CHR function, The original is to turn the number into ASCII code, such as Chr (10) is the carriage return.BEGIN Dbms_output.Put_Line (' Gogo ' | |CHR (10) | | ' Tot '); end;/Use here | | To connect characters, or you can use Concat to connect. However, Concat has only two parameters, that is, connecting two s

= sid_ DESC = (sid_name = ORCL) (Oracle_ HOME =/opt/oracle/product/11gr2)) LISTENER = (description_list = (DESCRIPTION = (A ddress = (PROTOCOL = TCP) (HOST = 192.168 . ) (PORT = 1521 ))) Adr_base_ LISTENER =/opt/oracle This file changed, and the Tnsnames.ora file in localhost changed to local IP, I do not know whether this has played a role, anyway changed is also true# Tnsnames.ora Network Confi

Transferred from: http://zhengdu.net/archives/152First, see if the remote end Oracle service is startedIf it does not start, start the Oracle servicePS: Create or delete Oracle ListenerSecond, remote-side Oracle ConfigurationLISTENER_ORCL =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.10) (PORT = 1521))Oraclr_connectio

Tags: des using os io file data ar ArtPL/SQL Connect Oracle Database 1, Brief introductionUse PL/SQL to connect to a remote Oracle database without installing an

Tags: PL/SQL developer do not install client connection to remote Oracle databasePL/SQL Developer is an integrated development environment designed specifically for the development of Oracle Database storage program units. Now tha

Today with PL/SQL to connect to a database old report ora-12541: TNS: No listener error. Solution: Refer to the SQL * Plus User's Guide and reference for more information.[Oracle @ vserever75 ~] $ Sqlplus/nolog SQL * Plus: Release

First, the problem descriptionThe oracle-client side is not installed locally, and because of limited machine resources, you want to connect to the remote database via PL/SQL developer. Simple installation PL/SQL developer cannot