The EDITOR_PKG.report function creates the output URL and opens it based on the ID of the request.

Requirements: PO distribution interface, original menu [view documents], standard output reports and data source XML can not be detailed to Distribution. Solution: Custom detailed report, and hang requests, PO issuance interface, using personalization, add a menu item [View Documents - Custom], which executes requests and autom ...

Posted on Sun, 16 Dec 2018 03:18:05 -0800 by martor

Step by step create ASP.NET MVC5 program [Repository+Autofac+Automapper+SqlSugar] (10)

Preface Friends, Hello, everyone. I'm Rector, writing ASP.NET MVC 5 series articles. [Step by step create ASP.NET MVC5 program Repository+Autofac+Automapper+SqlSugar] That guy. Today I bring you the tenth article in this series. Points of knowledge in this paper This article will share with you the knowledge of page planning and co-ordination. ...

Posted on Sat, 15 Dec 2018 23:24:03 -0800 by Garethp

Rownum,Rowid,row_number() and oracle paging queries

1.rownum and rowid are pseudo columns, but they are fundamentally different. rownum assigns one to each row based on the results of sql queries Logical number, different sql will lead to different rownum, but rowid is physical structure, when every record Insert to the database, There will be a unique physical record. rowid can be said to ex ...

Posted on Sat, 15 Dec 2018 22:33:04 -0800 by cap2cap10

Twenty-fifth bullet of ASM translation series: When will my rebalance complete ASM advanced knowledge

Original text: When will my rebalance complete Author: Bane Radulovic Translator: Wei Xinghua is a senior technical expert of Waterloo Science and Technology. He mainly participates in the R&D and design of the company's integrated machine products, monitoring products, disaster tolerance products and DBaaS platform. He has worked for E ...

Posted on Sat, 15 Dec 2018 01:15:04 -0800 by UnsuitableBadger

2018-04-26,KK Diary, Mistakenly Delete Table Space of DBMS_LOGMNR_D.SET_TABLESPACE

I. Case Study We have a colleague who executed DBMS_LOGMNR_D.SET_TABLESPACE ('TBS1') in the test environment and then dropped tablespace TBS1 INCLUDING CONTENTS and DATAFILES.As a result, system packages dbms_logmnr,DBMS_LOGMNR_INTERNAL,dbms_logmnr_d and so on can not be used.Unfortunately, we don't have a backup of the test en ...

Posted on Thu, 13 Dec 2018 21:18:06 -0800 by jalbey

oracle PL/SQL Calls Java to Generate Excel

Now there is a need to write oracle stored procedures to generate Excel files to the specified directory, but oracle's own API does not seem to be very powerful, so it can only be achieved through another more powerful language -- Java. There is a Java framework called POI, which is very useful for handling Excel. Now I record the process: 1. D ...

Posted on Thu, 13 Dec 2018 06:42:06 -0800 by fpbaum

MySQL Database - Initial Inquiry into Basic Operations of'Stored Procedures'(No References, IN,OUT) and Basic Concepts of Variable Terminology

stored procedure Stored procedures are precompiled sets of SQL statements and control statements stored in a name and processed as a unit. Stored procedures are stored in databases and can be invoked and executed by applications. They also allow users to declare variables and control processes. Stored procedures can rece ...

Posted on Thu, 13 Dec 2018 01:33:09 -0800 by EY

11.2.0.3.0 Play PSU Patch - Automation (p14727347_112030_AIX64-5L.zip)

11.2.0.3.0 dozen PSU patches (p14727347_112030_AIX64-5L.zip) Operating System Platform AIX 61009 grid and oracle versions 11.2.0.3   Preparations before patching 1. Backup the spfile file of ASM/RDBMS grid users $sqlplus '/as sysasm' SQL>create pfile='/apps/*****/backup/pfile_grid_201410.ora' from spfile; ora ...

Posted on Wed, 12 Dec 2018 04:48:06 -0800 by stridox

PostgreSQL Scenario and Performance Testing for HTAP Database 19 - (OLAP) User Portrait Circle Scenario - Array Intersection Query and Aggregation

Label PostgreSQL, HTAP, OLTP, OLAP, Scenario and Performance Testing background PostgreSQL is a database with a long history, which can be traced back to 1973. It was first awarded by the 2014 Computer Turing Prize winner and the originator of relational database. Michael_Stonebraker PostgreSQL has similar functions, performance, architectur ...

Posted on Wed, 12 Dec 2018 04:24:06 -0800 by altaergo

14 - (OLTP) String Search - Full Text Retrieval for HTAP Database PostgreSQL Scenario and Performance Testing

Label PostgreSQL, HTAP, OLTP, OLAP, Scenario and Performance Testing background PostgreSQL is a database with a long history, which can be traced back to 1973. It was first awarded by the 2014 Computer Turing Prize winner and the originator of relational database. Michael_Stonebraker PostgreSQL has similar functions, performance, architectur ...

Posted on Wed, 12 Dec 2018 02:51:06 -0800 by Pedro Sim