function and procedure is PL / SQL code to gather, usually in order to achieve a duty. Procedure does not need to return any value, and function returns a value, on the other hand, Package A group of function and procedure that have to be brought together to achieve a commercial function 25. Explain the usefulness of TABLE Function
ALTER INDEX index_name REBUILD; 25. Explain what partitioning is and what its benefit is. A table partition is also a table segment, and by using partitioning technique we can enhance performance of table access. 26. You have just compiled a PL/SQL package but got errors, how would you v...
12 :: In PL/SQL, what is bulk binding, and when/how would it help performance? Oracle's SQL and PL/SQL engines are separate parts of the kernel which require context switching, like between unix processes. This is slow, and uses up resources. If we loop on an SQL statement, we are...
SQL> select * from v$version; The command returns the release information, such as the following:Oracle9i Enterprise Edition Release9.2.0.7.0- ProductionPL/SQL Release9.2.0.7.0- ProductionCORE9.2.0.7.0ProductionTNS for 32-bit Windows: Version9.2.0.7.0- ProductionNLSRTL Version9.2.0.7.0- Product...
● 隐式游标是在执行插入(insert)、删除(delete)、修改(update)和返回单条记录的查询(select)语句时由PL/SQL自动定义的。 ● 显式游标的操作:打开游标、操作游标、关闭游标;PL/SQL隐式地打开SQL游标,并在它内部处理SQL语句,然后关闭它。 4、Oracle中字符串用什么连接?
2. oracle使用的脚本语言为PL-SQL,而sql server使用的脚本为T-SQL 微观上:从数据类型,数据库的结构等等回答 2. 如何使用Oracle的游标? 1. oracle中的游标分为显示游标和隐式游标 2. 显示游标是用cu rsor…is命令定义的游标,它可以对查询语句(select)返回的多条记录进行处理;隐式游标是在执行插入 (insert)、...
Oracle APEX interview questions – APEX-related examples: What is Page Zero in Oracle APEX? What are Collections in APEX? Could you give some usage examples? What would you call APEX Items in APEX, in PL/SQL, and in JS? How would you connect an Oracle APEX application to Active Directory...
The UTL_SMTP package was introduced in Oracle 8i and can be used to send emails from PL/SQL. Simple Emails In it’s simplest Continue reading Uncategorized Leave a comment Oracle R12 HR Payroll “Using Oracle FastFormual For Payroll Calculatins Posted on November 1, 2011 by Administrator Us...
Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers...
Database Administration | Oracle | Oracle Training | DBA Support | Oracle 12c DBA | GoldenGate | GoldenGate 12c | DBA Interview Questions | Goldengate Interview Questions | Natik Ameen