Create or replace package body account
Procedure accountpage(P_acctdate_from in date,P_acctdate_to in date,P_acctname in varchar2,P_cursor out Mr)AsV_sqlstring varchar2 (5000 );V_temp varchar2 (200 );V_fact_acct_id integer; -- entry IDV_acctname
Variables and constants can be defined when compiling PL/SQL programs. PL/SQL programs include:(1). scalar type (scalar)(2) composite type (composite)(3). Reference)(4). lob (large object)1. Scalar-Common Type When compiling PL/SQL blocks, if you
Generate a data window using the oracle Stored Procedure returned record set as a data source in PB
First, oracle Stored Procedure writing is different from MSSQL, with a big difference. For the stored procedure of the returned dataset, you must use
Oracle Advanced Programming, oraclesql Advanced Programming
Oracle's advanced programming mainly involves the use of the ten objects in the database. Here, I will share with you some of my notes on these skills. Hope to help you!
Before reading this
Ing between MySQL and Oracle Data Types (table form), mysqloracle
MySQL and Oracle databases are usually used at work. Because of some differences in data types between MySQL and Oracle, the following describes the relationship between the data
Obtain the number of rows in each subpartition of a specified partition table in batches!
Otherwise, manual query is too troublesome!
--- View the number of rows in each sub-partition of the specified partition table
Create or replace procedure
When connecting Oracle using. NET 2.0:In the 1.1 era, both using system. Data. oracleclient and. NET 2.0 were improved to dbprovider (system. Data. Common,It looks pretty, but it's okay when I use the Oracle stored procedure to return the result set.
The dbms_metadata.get_ddl package obtains the DDL script of the database object. As follows (executed in sqlplus ):1. Get the DDL statement of a table:Set serveroutput on
Set linesize 1000
Set feedback off
Set long 999999 ------ incomplete
1. Column and column conversion with fixed columnsFor exampleStudent subject grade---------------------------Student1 language 80Student1 mathematics 70Student1 English 60Student2 language 90Student2 mathematics 80Student2 100
Previously, I used C # to connect to the SQL Server database. Recently, due to work requirements, you need to use C # to connect to the Oracle database and operate the data in the database through the stored procedure to implement the function of
When calling the Oracle function, in order for the PL/SQL function to return multiple rows of data, a REF CURSOR or a data set must be returned. Ref cursor is limited to the data that can be selected from the query. The entire set must be specific
Oracle Advanced Programming
Oracle's advanced programming mainly involves the use of the ten objects in the database. Here, I will share with you some of my notes on these skills. Hope to help you!
Before reading this article, you can also refer to
This article illustrates the method of Oracle to implement row and column conversion. Share to everyone for your reference, specific as follows:
1, the row and column conversion of fixed number
Such as:
Student subject Grade
---------------
Use of dynamic SQL
Oracle is actually better than SQL Server, but it's definitely not as strong as it is legendary. This is the feeling of Oracle in these days. It seems that a lot of things are so much better to listen to than to see the perfect.
Dynamic SQLLimitations of 0.pl/sql BlocksCannot perform DDL operations (create, drop, alter);Partial DCL Operations (GRANT, REVOKE) cannot be performed.1. SyntaxDynamic SQL: The SQL statement to execute can be determined at execution time.When you
1. What is a cursor?A: A cursor is a data buffer opened by the system to the user, which holds the execution result of the SQL statement.Each cursor has a name that the user can use to extract data from the cursor and assign it to the variable.2.
In order for the PL/SQL function to return multiple rows of data, it must be done by returning a REF CURSOR or a data collection. This case of REF CURSOR is limited to the data that can be selected from the query, and the entire collection must be
I. Data types in Oracle1, String type. such as: char, nchar, VARCHAR2, nvarchar2.2, numeric type. such as: int, number (p,s), Integer, smallint.3. Type of date. such as: date, interval, timestamp.4. PL/SQL type. such as: Pls_integer, Binary_integer,
1 for LoopSyntax: BeginFor i in reverse 1..10 loopInsert into users values (i, ' Obama ');End Loop;EndNote: The loop variable i is implicitly incremented, so you cannot see2 Goto StatementThe goto statement is used to jump to a specific location to
Cursors for getting Started with PL/SQL basics PL/sql: Process Language (Procedure Language) and structured language (structured Query Language) A programming language that is a combination of Span style= "Color:rgb (51,51,51);
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.