10) What is PL/SQL? Oracle uses PL/SQL, which is an extension of SQL. PL/SQL generates more potent SQL queries by fusing the processing power of procedural languages with SQL's data manipulation capabilities. It tells the compiler what to do using SQL and how to do it using a procedura...
1_ORACLE 面试题及其答案(1_ORACLE interview questions and answers) 1_ORACLE 面试题及其答案(1_ORACLE interview questions and answers) 21. How do I determine the time zone for the database? Answer: SELECT, DBTIMEZONE, FROM, DUAL; 22. Explain the usefulness of GLOBAL_NAMES as TRUE Answer: ...
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...
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...
PL/SQL和SQL在Oracle中的主要区别包括:1、编程能力: PL/SQL是一种程序化语言,支持变量、条件语句和循环,而SQL主要用于数据查询和更新。2、执行方式: PL/SQL可以执行一整块代码,而SQL语句逐条执行。3、用途: PL/SQL适用于编写复杂的数据库应用程序,SQL用于简单的数据操作和查询。Orac SQL 数据库 数据 面试 ...
● 隐式游标是在执行插入(insert)、删除(delete)、修改(update)和返回单条记录的查询(select)语句时由PL/SQL自动定义的。 ● 显式游标的操作:打开游标、操作游标、关闭游标;PL/SQL隐式地打开SQL游标,并在它内部处理SQL语句,然后关闭它。 4、Oracle中字符串用什么连接?
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...
一:SQL tuning 类 1:列举几种表连接方式 hash join/ 用于equi-join, 耗CPU(hash计算),效率最高,因为只要对两张表扫描一次。一般用 于一张小表和一张大表进行join. sort-m oracle 职场 休闲 oracle 面试题 转载精选 高级devops 2011-11-23 17:16:12 ...
oracle使⽤的脚本语⾔为PL-SQL,⽽sql server使⽤的脚本为T-SQL 微观上: 从数据类型,数据库的结构等等回答 2. 如何使⽤Oracle的游标? 1). oracle中的游标分为显⽰游标和隐式游标 2). 显⽰游标是⽤cursor...is命令定义的游标,它可以对查询语句(select)返回的多条记录进⾏处理;隐式游标是在...