Learn about oracle database 11g pl sql programming, we have the largest and most updated oracle database 11g pl sql programming information on alibabacloud.com
. Create Database-related directories Diagnostic directory is added for Oracle 11g, which is $ ORACLE_BASE by default. [Oracle @ rh6 dbs] $ mkdir-p $ ORACLE_BASE/admin/test1/adump [Oracle @ rh6 dbs] $ mkdir-p/u01/app/oracle/oradat
I. Problem Description Install RAC of 11.2.0.1 on Oracle Linux 6.1 and run the root. Sh script when installing grid. The error is as follows: [Root @ Rac1 bin] #/u01/APP/11.2.0/GRID/root. Sh Running Oracle 11g root. Sh script... The following environment variables are Setas: Oracle_owner = Oracle ORACLE_HOME =/u01/AP
=spno;End-----3. How to call in Java---1. Create CallableStatement CS =ct.preparecall ([Call Sp_pro9 (?,?)]);----Cs.setint (1,10);----Cs.registeroutparameter (2,oracle.jdbc.oracletypes.cursor);--run--cs.execute ();--Get the result set/*resultset rs= (ResultSet) Cs.getobject (2);while (Rs.next ()) {....}*/---------------------Exception Handling---------Case_not_foundData_not_foundCursor_already_openDup_val_on_index Unique index repeatedInvaild_cursor run operation on an illegal cursor for example
later found that it is not at all, and that the error Dup_val_on_index, his book is also wrong.Here is an anonymous blockDate.sqlDECLARE l_date date;BEGIN l_date: = SYSDATE-5; Dbms_output. Put_Line (l_date); end;/I still don't know how to call that process, although I tried it before, but I didn't remember it.I'm going to try to write a call on my own, I write a process for printing time, and then call it in an anonymous block.Get_date.sqlCREATE OR REPLACE PROCEDURE get_date (num_in in number)
the 7 - bit Oracle database installed on the Win Oracle client, with Plsql Connection Oracle appears when situation , only user name, password, database fill or select box, there is no "login as" (role) selection box. Solution: 1) Installation
Oracle|sql Language Oracle Pl/sql Language Foundation 2002-8-23 Oracle Pl/sql Language Basics Pl
) service name" is the global database name of the database you created earlier. At this point, a service named Server_ip, Server_port, and db_name three features are configured to complete. Click Next. 5. Test or Complete: Click "Finish" to exit the wizard. Or click the "Test" button to test whether the above configuration is correct: Make sure that the user ID you used for your test is not locked. You
The ORACLE tutorial is the basics of Oracle PL/SQL language. PL/SQL is an extension of ORACLE's standard database language. ORACLE has integ
The Oracle tutorial you are looking at is the introductory Foundation for Oracle Pl/sql languages. Pl/sql is Oracle's extension of the standard database language,
match.Then I wrote an example:CREATE OR REPLACE PROCEDURE give_bonus (emp_no_id in number, bonus in number) AUTHID Current_userisbegin dbms_output.Put_Line (emp_no_id); Dbms_output. Put_Line (bonus); END give_bonus;/This is followed by the use of the case expressiondeclarel_salnumber; beginselectsalintol_salfromemp whereempno=7839;dbms_output. Put_Line (l_sal); give_bonus (7839, CASE whenl_sal>=1000andl_salSo it's actually an expression, and then the expression gets a result.After the introduct
= (SERVER = dedicated) (service_name = ORCL) ) ) You can add your own configuration at the end of the Tnsnames.ora fileXXXXX = (DESCRIPTION = ( ADDRESS = (PROTOCOL = TCP) (HOST =xxxxx) (PORT = 1521)) (Connect_data = (SID = ORCL) (SERVER = dedicated) ) )Here is a misunderstanding is if your connection name (that is the first line above the xxxxx), the front can not have any characters, space is not.Otherwise PL
Today, I am working on an OA report. I use a stored procedure to calculate some data. When doing a for xxx in xxxx loop end loop; loop, I never knew it was Mao. I can't catch the no_data_found exception in for any more. Once this no_data_found Oracle occurs, it automatically jumps out of the for loop, but I don't know what went wrong, that was depressing for an hour. Shit. Later I remembered that pl/
Today, I am working on an OA report. I use a stored procedure to calculate some data. When doing a for XXX in xxxx loop end loop; loop, I never knew it was Mao. I cannot catch the no_data_found exception in for any more. Once this no_data_found occurs Oracle will automatically Jump Out Of The for loop, but I don't know where the error occurred. It was a depressing hour. Shit. Later I remembered that PL
The previous blog describes the method of backing up Oracle with the Navicat tool, which describes how to import and export an Oracle database using the PL/SQL developer tool.PL/SQL Developer is one of the primary tools used by
Oracle PL/SQL practiceBasic InformationAuthor: (English) bilington (A.) and so on, Lu Tao [Translator's introduction]Press: People's post and telecommunications PressISBN: 9787115294852Mounting time:Published on: February 1, November 2012Start: 16Page number: 166Version: 1-1Category: Computer> database>
the rownum condition, that is, the first 5 data in the physical location, and then sorts the data according to the order by field, rather than the first sort, and then the number of specific records we expect.There are typically three different types of dynamic SQL methods that are executed: Use the Execute IMMEDIATE statement.In addition to not being able to handle multiline query statements, other dynamic
The main content of this article is as follows: Chapter 1 Introduction to PL/SQL programming 1.1 SQL and PL/SQL 1.1.1 what is PL/SQL? 1.2 ad
the Start.bat file in the Plsql Developer directory. The following are the contents of Start.bat: @echo offSet Path=f:\app\administrator\product\instantclient_11_2Set Oracle_home=f:\app\administrator\product\instantclient_11_2Set Tns_admin=f:\app\administrator\product\instantclient_11_2Set Nls_lang=american_america. Zhs16gbkStart Plsqldev.exe where set Nls_lang=american_america. ZHS16GBK's ZHS16GBK is your database encoding. Then start your plsql Dev
The Oracle tutorial being looked at is: PL/SQL implementation of Oracle database task scheduling. Absrtact: This article mainly on the database recovery and system task scheduling, combined with the general
Modify the database configuration file: Tnsnames.ora "My database location: D:\app\Icey-evil\product\11.2.0\dbhome_1\NETWORK\ADMIN"Add the following to the server address:10.88. 250.28 = = =10.88. 250.281521) ))) (= ORCL ) )) Description: HOST = 10.88.250.28 is the Oracle server that needs to be connected Ip,service_name = ORCL is a connec
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
