23. How to encrypt PL / SQLorder? Answer: WRAp 24. Explain the differencesbetween FUNCTION, PROCEDURE, and PACKAGE Answer: function andprocedure 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, onth...
It ensure the use of consistent naming conventions for databases and links in a networked environment. 3. What command would you use to encrypt a PL/SQL application? WRAP 4. Explain the difference between a FUNCTION, PROCEDURE and PACKAGE. They are all named PL/SQL blocks. Function must retu...
13. What is explain plan and how is it used The EXPLAIN PLAN command is a tool to tune SQL statements. To use it you must have an explain_table generated in the user you are running the explain plan for. This is created using the utlxplan.sql script. Once the explain plan table exi...
How SYSDATE function works in PL/SQL, The PLSQL SYSDATE function will returns current system date and time on your database. There is no any parameter or argument for the SYSDATE How to convert extracted value from datetime to char in Oracle? Question: In Oracle PL/SQL, I want to convert...
以下题目,可根据自己情况挑选题目作答,不必全部作答.您也可以就相关问题直接找负责面试人员面述而不笔答…… 一:SQL tuning 类 1:列举几种表连接方式 2:不借助第三方工具,怎样查看sql的执行计划 I) 使用Explain Plan,查询PLAN_TABLE; EXPLAIN PLAN SET STATEMENT_I ...
● 隐式游标是在执行插入(insert)、删除(delete)、修改(update)和返回单条记录的查询(select)语句时由PL/SQL自动定义的。 ● 显式游标的操作:打开游标、操作游标、关闭游标;PL/SQL隐式地打开SQL游标,并在它内部处理SQL语句,然后关闭它。 4、Oracle中字符串用什么连接?
Oracle DBA Job Interview Questions and Answers 1:: When using Oracle export/import what character set concerns might come up? How do you handle them? Be sure to set NLS_LANG for example to "AMERCIAN_AMERICA.WE8ISO8859P1". If your source database is US7ASCII, beware of 8-bit characters...
1.Oracle跟SQL Server 2005的区别?宏观上:1). 最大的区别在于平台,oracle可以运行在不同的平台上,sql server只能运行在windows平台上,由于windows平台的稳定性和安全性影响了sql server的稳定性和安全性2).oracle使用的脚本语言为PL-SQL,而sql server使用的脚本为T-SQL微观上: 从数据类型,数据库... ...
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...
17. Oracle PL-SQL 18. Oracle Programmatic Constructs19. Oracle Scenarios20. Oracle Security21. Oracle Technology Network (OTN)22. SQL Plus SAMPLE QUESTIONS Q. ) Explain When can hash cluster used?Ans: Hash clusters are useful in cases where :(i) There is a uniform, even and predictable ...