Atitit View parametric solution Oracle and MySQL version attilax summary. docx

Atitit View parametric solution Oracle and mysql version attilax summary . docx

1.1. Package mechanism 1

1.2. global variable mechanism 1

1.3. Temporal table mode,Oracle MySQL supports 1

1.1. package mechanism

Oracle Support

Build Baotou

Create or Replace package P_view_param is

-- parameter one

function Set_param (num number) return number;

function Get_param return number;

-- parameter two

function set_starttime (num timestamp) return timestamp;

function get_starttime return timestamp;

End P_view_param;

Build Package body

FUNCTION set_starttime (num TIMESTAMP) RETURN TIMESTAMP is

Ati test oracle11 not good use, teacher build body can't build up

1.2. global variable mechanism

Oracle does not seem to support MySQL seemingly.

1.3. Temporal table mode,Oracle MySQL supports

Setting parameters

Update "Ez_flow_timeparam" set "StartTime" =to_timestamp (' 2015-06-06 ', ' yyyy-mm-dd ')

SELECT * from "Ez_flow_timeparam"

SELECT

*

From

Ez_flow_hi_procinst left joins "Ez_flow_timeparam" P on Ez_flow_hi_procinst. Start_time_>p. " StartTime

WHERE

ROWNUM < 99

and Start_time_ >p. " StartTime

this can ... A SQL query, you need multiple SQL execution.

Reference

Oracle creates a parametric view - the dream to realize technology Freedom - Blog channel -CSDN.NET.html

in the create a view with parameters in Oracle -Oracle database column - Red and Black Alliance . HTML

author :: Nickname: Old Wow's paw claw of Eagle idol iconoclast Image-smasher

Bird King "Bird Catcher Kok devout pious religious defender Defender of the Faith. Caracalla red cloak Caracalla red cloak king of beasts

abbreviation:: Emir Attilax Akbar Emile Atiraca

Full Name:: Emir Attilax Akbar bin Mahmud bin Attila bin Solomon bin Adam Al Rapanui Emile Atilax Akbaben Maham Solomon Ben Adam Arrapanui

Common name: Etila (Ayron), Email:[email protected]

title:Head of Uke headquarters, founder of Global Grid project,

Uke Friendship Association president Uke Hunting Association president Emir Uke Tribe chief Grand Chief,

Uke, Minister of Religious and Cultural Integration Affairs, Vice-Chairman of the Uke Reformation Commission

Uke system and chairman of the major conference committee, Uke Security Department Chief Brigade, Uke System Inspection Committee vice President,

UKE Chief CTO Software Division Director of Technical department deputy Director of Research and Development department Director of Product department deputy Manager Project department deputy Manager Uke Science and Technology research Institute Dean Uke Software Training Master

Uke Polynesia District chain Head of the area responsible for the Kingdom of Tonga Uke Kerr Glen, chain head, Line Is. district chain head, Uke Bouvet and South Georgia and South Sandwich Is. region chain Head

Uke, chairman of the Association of Software Standardization, vice president of Uke Database and storage Standardization Association

Uke, founder of Uke Hospital and Medical school, vice president of lifelong Education School

UEC, president of UECIP, director of UKE document Retrieval department, head of Department of image processing machine vision

Uke, chief Dean of the School of image processing and machine vision

Uke Outdoor Sports Association chairman of the resort chief Mayor Uke Press editor

reprint Please indicate source:Attilax's column? http://www.cnblogs.com/attilax/

--atiend V8

Atitit View parametric solution Oracle and MySQL version attilax summary. docx