In the process of operation, it is sometimes necessary to send the data result set of SQL query in HTML form, so it is necessary to stitch the result set of SQL query into HTML code. There are usually two different ways to do this. One is to use the cron job directly to poll and do it using the OS level mail program. Its query result set can be directly under Sql*plus by setting HTML tags to automatically implement HTML table Form. One way is to use the scheduler job in Oracle to poll periodical
At ordinary times, we usually need to write some small PL/SQL programs, triggers, functions, packages, and so on. The following is a small example, where sparrows are kept small and dirty. You can draw a line from each other.
Conn HR/hr
SQL> Create Table EMP as select * from employees;
SQL> Create Table dept as select * from orders ments
PL/SQL BlockDeclareV_ename varchar2 (20 );BeginSelect first_name into
The error message "pldeveloper" appears when PL/SQL Developer connects to a 64-bit database.
Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.
Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/41479997
After 64bit oracle11g database is installed, connect to the database using
PL/SQL smart call stack Analysis
PL/SQL smart call stack Analysis
The three DBMS_UTILITY functions(DBMS_UTILITY.FORMAT_CALL_STACK, DBMS_UTILITY.FORMAT_ERROR_STACK, and DBMS_UTILITY.FORMAT_ERROR _ BACKTRACE) have been crucial aids in diagnosing and resolving problems in PL/SQL code. the UTL_CALL_STACK package recognizes the importance of this data and takes a big
1. Character SetThe character set of PL/SQL includes:
All uppercase and lowercase letters: include a~z and a~z.
Number: Includes 0~9.
Whitespace characters: include tabs, spaces, and carriage returns
Other common English symbols
2. IdentifiersIdentifiers are used to define PL/SQL variables, constants, exceptions, cursor names, cursor variables, parameters, subroutine names, and oth
Problem? PL/SQL Developer client installation and configuration and handling of some problemsFirst, the problem analysiswhen using the PL/SQL Developer Client tool, be sure to look at the two-point knowledge that is different from SQL Server and MySQL client as it can be used directly. Oracle database, also divided into 32-bit and 64-bit, but PL/SQL is a 32-bit
Anonymous PL/SQL block reviewDECLARE (optional) defines the object to be used in a PL/SQL block BEGIN (MUST) EXECUTE statement EXCEPTION (optional) error-handling statement END; Must Anonymous blocks (starting with declare or begin) are compiled each time they are used. anonymous blocks are not stored in the database, and they cannot be called from other PL
To connect to Oracle, you often need to install an ORACLE client of hundreds of megabytes, which is very troublesome. This section describes how to use a thin client that does not need to be installed with PL
To connect to Oracle, you often need to install an ORACLE client of hundreds of megabytes, which is very troublesome. This section describes how to use a thin client that does not need to be installed with PL
I usually encounter some problems in PL/SQL programming. I will summarize them in the form of Q A for you to share.
1. Can pipelines be used to improve processing efficiency when you need to load a large amount of data streams to a table or process a large amount of data streams?MPs queue functions are very convenient for improving the performance of parallel queries. they speed up data loading to tables. MPs queue functions are summarized as follow
PL/SQL variables, constants, and parameters must have a valid data type, specifying a valid range of storage formats, constraints, and values.
category
Description
Scalar
Single value does not have an internal component, such as number, DATE, or BOOLEAN
Large Object (LOB)
Store large objects that point to other data items such as text, graphics images, video clips, and sounds
PL/SQL Developer is an integrated development environment that specializes in developing applications for Oracle databases. At the same time, PL/SQL is a procedural languageCalled the process SQL language (procedural language/sql). PL/SQL is an extension of the Oracle database to the statement. In normal SQLThe use of the statement adds to the characteristics of
The previous blog introduced how to use the Navicat tool to back up Oracle. This blog introduced how to use the PL/SQL Developer tool to import and export Oracle databases.
PL/SQL Developer is one of the main tools used by Oracle databases to import and export databases. This article describes how to import and export Oracle databases using PL/SQL.
1. Oracle Dat
Operation Maintenance and working principle of PL single-machine dust Catcher in NingxiaPL stand-alone filter is a small air volume, high dust removal efficiency of small single-machine bag dust collector, important by the fan, flat filter bag, shell, ash motor composition, is used in the workshop internal consumption of dust management, such as: lathe processing, polishing and grinding, ceramics, glass, refractory materials manufacturing, to meet the
PL/SQL-related data dictionary and plsql-related dictionary
Data Dictionary related to PL/SQLHttp://www.oracle.com/technetwork/issue-archive/2012/12-nov/o62plsql-1851968.html
Sometimes, we encounter the following problems during PL/SQL development:1) What database objects does my program depend on?2) which package calls a subroutine or variable in another packag
Easy-to-use PL/SQL Developer settings, pldeveloperSome time before the easy-to-use PL/SQL Developer settings, the company trained pl/SQL related knowledge internally. Here I will share my settings that I think are very convenient. 1. When PL/SQL Developer is used, PL/SQL Dev
Please contact me if you have any questions :)
Coding FAQ (PL/SQL and Java)1. the PL/SQL data type is incorrect. For example, aac001 is of the varchar2 type, but it is not included in ''. Although the program can be queried, it poses a hidden risk for future performance problems.Select aac002 from ac01 where aac001 = 123456;Select aac002 from ac01 where aac001 = '000000 ';2. The code is too long.No matter i
Label:PL/SQL exception handling for Oracle databaseExceptions are abnormal events that occur during the course of a program's operation, usually caused by hardware problems or programming problems. Even the best-written programs may encounter errors or unanticipated events during the PL/SQL programming process. A robust program should be able to properly handle various anomalies and recover from them as much as possible. 1. Exception Handling Exceptio
Label:1. PL/SQL Overview1) ConceptPL/SQL (procedural language) is an extension of Oracle based on the standard SQL language, enabling you to define variables, use logical control statements, and so on: The default Oracle can only process one SQL statement at a time, Each SQL statement sends a request call to the server, and if you use PL + SQL, the statement in a block acts as a group, sending only one requ
Many oracle database developers prefer PLSQL functions and storage to simplify the code.
Many oracle database developers prefer PL/SQL functions, storage, and so on to simplify the code.
Many Oracle database developers prefer PL/SQL functions, storage, and so on to simplify the code.
Recommended reading:
Use PL/SQL to execute java storage to obtain the MAC a
Solve PL/SQL Dev connection to Oracle a blank prompt box appears, ploracle
The first time Oracle was installed, it was installed in a virtual machine. When PL/SQL Dev was used to connect to a remote database, a blank prompt box pops up. After a long time of searching online, there were many solutions, but it cannot solve this problem.
No way, you can only study it on your own. After about a day, do it well
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.