Implementation of Oracle General Query Using SQL*FORM and PRO*C

Abstract

Abstract: This paper introduces a method of realizing the general query using SQL * FORM and PRO * C.The general query is very frie idly with users, for it allowing user to select the query table name.query condition and the column name for display in a convenient manner.

摘要： 介绍了一种利用SQL*FORM和PRO*C结合使用的实现用户通用查询的方法。这种通用查询方法．允许用户灵活地指定查询表名、查询条件及查询显示的字段名，对用户十分友好。

关键词: 通用查询, Oracle, 管理信息系统（MIS）

CLC Number:

TP311

Tang Xuebing. Implementation of Oracle General Query Using SQL*FORM and PRO*C[J]. , 1998, 24(11): 71-72.

唐学兵. 基于SQL*FORM和PRO*C的Oracle通用查询实现[J]. , 1998, 24(11): 71-72.

[1]	WANG Ting, LIU Mingming. Improved PBFT Consensus Algorithm Based on Node Bidding and Reputation Mechanism [J]. Computer Engineering, 2026, 52(11): 308-318.
[2]	ZHANG Ru, SUN Weifeng, ZHANG Peng, ZHANG Chao, DAI Yongshou. Plug-in-based Electromagnetic Signal Analysis Software Architecture Design Method [J]. Computer Engineering, 2026, 52(11): 435-443.
[3]	DING Lin, YANG Yang, GUO Caili, GUO Jianzhang, LI Zheng. A Text-to-SQL Method Based on Fine-Tuning Large Language Models with Table Creation Information [J]. Computer Engineering, 2026, 52(11): 402-411.
[4]	LI Xue, WANG Yawen, ZHANG Qianjin. Automatic Naming of Source Code Based on Information Retrieval [J]. Computer Engineering, 2024, 50(6): 304-310.
[5]	LI Yakang, CHEN Gang. Automated Selection for Physical Models of Small-Angle Neutron Scattering [J]. Computer Engineering, 2024, 50(6): 56-64.
[6]	XUAN Yizhao, ZHAO Hongwu, JIN Yu. A Dual-Chain-Based Consensus Mechanism for Blockchain [J]. Computer Engineering, 2024, 50(5): 139-148.
[7]	JIANG Huizhen, SUN Yanchun, HUANG Gang. GitHub Hierarchical Learning and Retrieval Service Based on Knowledge Graphs [J]. Computer Engineering, 2024, 50(5): 16-25.
[8]	WANG Ziheng, JIANG Zhongding. Enhanced Desktop Display System Supporting Multi-Modal Interaction [J]. Computer Engineering, 2022, 48(7): 177-188.
[9]	XU Fu, HAO Liang, CHEN Feixiang, LI Dongmei, CUI Xiaohui. Program Comparison Analysis Method for Open Source Code Reuse [J]. Computer Engineering, 2020, 46(1): 222-228,242.
[10]	ZHANG Wanying, CAO Xiaomei, CHEN Wei. Solution for Environment Interaction Problem in Whitebox Fuzz Testing [J]. Computer Engineering, 2020, 46(1): 216-221.
[11]	ZHANG Shutao, TAN Haibo, CHEN Liangfeng, Lü Bo. An Efficient Load Balance Strategy for Distributed Crawler System [J]. Computer Engineering, 2019, 45(11): 62-67.
[12]	YANG Zhenglong, GAO Jianhua. User-oriented Performance Analysis of Search Engine Based on Metamorphic Test [J]. Computer Engineering, 2019, 45(10): 52-56,63.
[13]	WANG Chenxu, WANG Xiaochen, YU Dunhui, WU Shan. Software Crowdsourcing Task Decomposition Algorithm Based on Dynamic Decoupling [J]. Computer Engineering, 2019, 45(8): 120-124,134.
[14]	WANG Chenxu, YU Dunhui, ZHANG Wanshan, ZHANG Xingsheng. Module Allocation Algorithm for Software Crowdsourcing Based on Core Degree Sorting [J]. Computer Engineering, 2019, 45(7): 66-70.
[15]	NI Hong, LIU Xin. Multi-Core optimization technology of unstructured grid based on Sunway TaihuLight [J]. Computer Engineering, 2019, 45(6): 45-51.

Please choose a citation manager

Content to export