pl sql complete tutorial

The first time to install Oracle, installed in the virtual machine, with PL/SQL dev connection to the remote database is always pop-up blank prompt box, online search for a long time, the solution is also a lot, but there is no way to solve my situation.No way, can only study, after about a day, or well done, write a summary.There are several possible solutions to this problem:1. Insufficient permissions, r

configuration file: C: "oracle" ora90 "network" admin "tnsnames. ora # Generated by Oracle configuration tools. Lilo = (Description = (Address_list = (Address = (Protocol = TCP) (host = 10.33.220.157) (Port = 1521 )) ) (CONNECT_DATA = (SERVICE_NAME = lilo) ) ) Extproc_connection_data = (Description = (Address_list = (Address = (Protocol = IPC) (Key = extproc0 )) ) (CONNECT_DATA = (SID = plsextproc) (Presentation = Ro) ) ) Here, you can configure it based on your actual situation. Then open

No way, only their own research, after about a day, or do a good job, write a summary. There are probably several solutions for this problem: 1. Insufficient permissions, resulting in pop-up empty bar prompt box. (directly on the link) Http://jingyan.baidu.com/article/066074d6760959c3c21cb0d6.html Right-click on the Pl/sql icon---properties---compatibility--Administrator to run this program on the h

I believe you are attracted by the words of performance, but I want to focus on the optimization of the idea, this is more important than the optimization skills, and the result, I do not want to say that it is a hundredfold ascension, "from the Black" "a bit."There is a real idea to discuss with you, is a SQL statement if the original run 20 seconds, optimized to 1 seconds, the performance of the increase is 20 times times or increased by 95%. Of cou

Tags: syntax representation length unit char PL/SQL har designation FFFFFF(1) varchar2 Syntax: varchar2 (maxlength) A variable-length string is stored, and the parameter maxlength indicates that the maximum length of the string can be stored, which must be given when the variable is defined (because VARCHAR2 does not have a default maximum length). The maximum length of the parameter maxlength can be 32767.

the table, and if you do, you will be prompted not to export, which is the first and third way to export. The third type is exported to. Pde format, the. PDE is PL/SQL developer own file format, can only be imported and exported by PL/SQL developer; can't use the editor to view, efficiency don't know how PS: Only the

log on as an administrator, set pause on setting the Suspend property is on, the query will be paused before the first page is returned, press Enter and the next screen will be displayed automatically.Second, PL/SQL is the Oracle's procedural programming language, which defines a large number of grammars that users can follow to define blocks of code to complete

Today, the second configuration of PL/SQL developer, said that the egg hurts, yesterday because moved a thing and then inexplicably can not connect the database, always show a variety ofError, I moved the thing is because the Chinese will show garbled, (because I am using 32-bit PL/SQL developer to connect 64-bit Orcal

Tags: log cheng Baidu Oracle. com targe install Oracle detail getThe simple way to connect a remote database via PL/SQL is to install the Oracle client, and one way is to not install the client, but you need to create the necessary configuration files yourself, the following is a simple record of the process of installing the client.A tutorial on the web that doe

Transferred from: Larry. Yue's Http://miracle.blog.51cto.com/255044/93450 Copyright: Original Works are allowed to be reproduced. During reprinting, be sure to mark them as hyperlinks. Original Article Source , Author information and this statement. Otherwise, legal liability will be held. Http://miracle.blog.51cto.com/255044/93450 For PL/SQL objects such as the process, function, or package of writing data

configuration. Here we choose to use the install-free Oracle client. Reason:1. easy to use. 2. not with other dependent Oracle the program conflicts. 1. Download instantclient-basic-nt-11.2.0.3.0.zip Just download the Instantclient-basic-nt-11.2.0.3.0.zip, and the rest is a package that expands according to different needs.: http://www.oracle.com/technetwork/topics/winsoft-085727.html 2.unzip to the local machine because we now both the client and the server are on the local machine, all I un

, formatting, and replacement of values, and you can use them to find adjacent values. The following example shows how to use the REGEP_SUBSTR function to find any repeated alphanumeric values separated by spaces. The displayed result is a substring that identifies the duplicate word is.SELECT REGEXP_SUBSTR ('The final test is The implementation ','([[: Alnum:] +) ([[: space:] +) \ 1') AS substrFROM dual SUBSTR------Is Matching Parameter optionsYou may have noticed that regular expression operat

Tags: plsql developer ora-00936Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.The blog:http://blog.csdn.net/huangyanlong/article/details/49897839 of Blue Some time ago, when attempting to extract data using PL/SQL developer, a ora-00936 error was encountered while executing the script.Query Error ora-009

directory, as well as the Sqlnet.ora.) Then determine whether the host configuration is correct, if host is the hostname, you need to remove the domain name after the hostname)3. Configuring the Oracle Home and OCI libaray for PL/SQL developerEnter the PL/SQL Developer in non-logon mode, designate the Oracle home path

Restore the tables drop by pl SQL in oracle by mistake View tables in the recycle bin Select object_name, original_name, partition_name, type, ts_name, createtime, droptime from recyclebin; Restore table SQL> flashback table test_drop to before drop; orSQL> flashback table "BIN $ B + XkkO1RS5K10uKo9BfmuA = $0" to before drop; Note: The full-text index cannot be r

, 197.9333, 197.9333, 197.9333, 197.9333, 0.00012567 ); 1 row inserted SQL> COMMIT; Commit complete SQL> SELECT * FROM hjm_num_test; A B C D E F 1 123.3333 123.33 100 123 123 -0.00030 2 197.9333 197.93 200 198 198 0.00013 (Displayed in the

Looking at the fat Oracle client on my computer, I almost never used anything like the Enterprise Manage Console. Its existence is a waste of my computer space. So I checked on the Internet to see if I could unmount the ORACLE client and use PL/SQL normally. It turns out that this method is available (I did my research and tried it ). Step 1: First go to oracle Http://www.oracle.com/technology/software/tech

variableD continue clicking Step into until you are finished. The test window is returned.E View the parameter list and verify that the M,b value is 8, 4.　　　Click Save in the Test window to save the test code. When you reopen it later, the values of the parameters you have entered are saved, so that you don't have to re-enter the parameter values for each test.For parameters with a return type of cursor, the data is not displayed directly, there is a button to the right of the list's parameter

The plsql block that only contains the execution part setserveroutputon -- open the output option begindbms_output.put_line ( Only pl/SQL block including execution part set serveroutput on -- open the output option begin dbms_output.put_line ( Pl/SQL block that only contains the execution part Set serveroutput

I have just joined a new project recently. The requirements have been completed and will enter the detailed design stage. The project framework should use a multi-project system framework that is being developed by other project teams and use this main framework to develop modules of our own system. I have learned about the composition of this framework over the past few days, mainly uses the WCF Service, entityframework 4.1 Framework, and ext. NET component development, by the way, I learned EF