存储过程和包 [英] Stored procedure and packages

问题描述

嗨
我是oracle存储过程和包的新手。

我想了解它以及为什么我们更喜欢SP而不是内联查询。

什么是使用SP包装。

我试过阅读一些文章，但我明白了解坦诚的原因。


您能否在SP中提供插入/删除/更新/选择查询的示例？



感谢和问候

Akshay 。

Hi I am a newbie to oracle stored procedure and package.
I would like to learn about it and why we prefer SP instead of inline query.
Whats the use of putting SP in package.
I have tried to read a few articles but i dint clearly understand the reason to be frank.

Can you please provide an example of insert/delete/update/select query in SP?

Thanks & Regards
Akshay.

推荐答案

过程或函数是一个模式对象，由一组SQL语句和其他PL / SQL结构组成，组合在一起，存储在数据库中，作为一个单元执行以解决特定问题或执行一组相关任务。



包封装相关程序，函数以及相关的游标和变量作为数据库中的一个单元一起使用。



其他问题请参考Oracle [文档]和 [教程]。

A procedure or function is a schema object that consists of a set of SQL statements and other PL/SQL constructs, grouped together, stored in the database, and executed as a unit to solve a specific problem or perform a set of related tasks.

Packages encapsulate related procedures, functions, and associated cursors and variables together as a unit in the database.

For rest of the questions please refer to the Oracle [documentation] and [tutorial].

这篇关于存储过程和包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！