Supercharge Your Innovation With Domain-Expert AI Agents!

Method and system for encapsulating SQL statements

A statement and corresponding technology, applied in the field of program development, can solve the problems of low efficiency and complexity of Oracle database management

Inactive Publication Date: 2014-11-12
杭州勒卡斯广告策划有限公司
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in the prior art, when using SQL statements to manage the Oracle database, it is necessary to input a large number of SQL codes (usually hundreds of characters), which is very complicated.
This further leads to relatively low efficiency in the management of the Oracle database in the prior art

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for encapsulating SQL statements
  • Method and system for encapsulating SQL statements
  • Method and system for encapsulating SQL statements

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0032] In order to make the above objects, features and advantages of the present invention more comprehensible, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0033] figure 1 It is a flowchart of an embodiment of a method for encapsulating SQL statements in the present invention. Such as figure 1 As shown, the method may include:

[0034] Step 101: Obtain the data ty...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method and a system for encapsulating (Structured Query Language) statements. The method comprises the steps of obtaining the data type of each output parameter in SQL statements to be encapsulated, establishing a user-defined type, and creating a function containing the SQL statements to be encapsulated, wherein the user-defined type comprises one or more variables, and the data type of each variable corresponds to the data type of one output parameter in the SQL statements to be encapsulated; the function further comprises at least an output parameter of which the type is the same as the user-defined type. The method or system is capable of realizing the encapsulation of the SQL statements by use of the function without inputting lots of SQL codes, and also realizing management on the Oracle database.

Description

technical field [0001] The invention relates to the field of program development, in particular to a method and system for encapsulating SQL statements. Background technique [0002] Structured Query Language (SQL) is a database query and programming language used to access data and query, update and manage relational database systems. Structured Query Language is a high-level non-procedural programming language that allows users to work on high-level data structures. [0003] In the prior art, the management of the Oracle database generally involves inputting or pasting SQL statements. However, in the prior art, when using SQL statements to manage the Oracle database, it is very complicated to input a large amount of SQL codes (usually hundreds of characters). This further leads to relatively inefficient management of the Oracle database in the prior art. Contents of the invention [0004] The object of the present invention is to provide a method and system for encaps...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
CPCG06F16/2433
Inventor 郭铁志张宝玉马向晖
Owner 杭州勒卡斯广告策划有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com