43) What is PL/SQL, Why do we need PL/SQL instead of SQL, Describe your experience working with PLSQL and What are the difficulties faced while working with PL SQL and How did you overcome them? PL/SQLis a procedural language extension with SQL Language. Oracle introduced PL/SQL It is...
Answer:%ROWTYPE & %TYPE are the attributes in PL/SQL that can inherit the datatypes of a table defined in a database. The purpose of using these attributes is to provide data independence and integrity. If any of the datatypes or precision gets changed in the database, PL/SQL code gets...
13.什么是存储过程,优点是什么? 存储过程就像我们编程语言中的函数一样,封装了我们的代码(PLSQL、T-SQL)。存储过程的优点: 能够将代码封装起来保存在数据库之中让编程语言进行调用存储过程是一个预编译的代码块,执行效率比较高一个存储过程替代大量T_SQL语句 ,可以降低网络通信量,提高通信速率 14.什么是三范式 第...
Ans:A placeholder is a column that is an empty container at design time. The placeholder can hold a value at run time has been calculated and placed into It by pl/sql code from another object. You can set the value of a placeholder column is in a Before Report trigger. Store a Tempor...
Home Interview Questions Oracle Basics Difference between IS and AS in oracle What is the difference between IS and AS in Oracle PL/SQL..? Interview Candidate Feb 24th, 2015 4 8052 Basics Answer First Prev Next Last Showing Answers 1 - 4 of 4 AnswersDeval Parikh Mar 17th, 2015 No ...
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?
Ans : PL/SQL Listener, Servlet Engine, OJSP Engine 14. What is jserv? Ans : jserv is nothing but servlet engine which will run u r servlets. It’s a module of apache which supports servlets. 15. What is self service application?
JavaInhand Tutorial: Get the latest Tutorials About Oracle Application Express(Oracle APEX),PL/SQL,SQL,Difference Between,HTML,CSS,Javascript etc
SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql 7. Why DB-CM-ADMIN are always insatlled on the same machine in Oracle Applications in Multi Node Installation ? Ans: There is no restriction to install all of them on a single machine,but if we install them on 3 different machines then when we ...
Check out the top PL/SQL Interview Questions to learn what is expected from SQL professionals! Inserting PL/SQL Records into the Database Using a single variable of type RECORD or percent ROWTYPE in the VALUES clause instead of a list of columns, you may insert records into database rows ...