What is the earned/unearned discount in oracle application?What is the Defaultar?What is the profile class of a customer?
What is the difference between Varray And Nested Table?
Latest Answer: They are Oracle data types those who knoww any language like C and java then it is easy to understand the concept of Varray, as it is related to ARRAY structure of C or java language. where as Nested Table concept is related to Struct data type of ...
What is the function of SMON ?
Latest Answer: perfrom instance recovery when the database is responded after instance fail ...
What type of value does a global variable support ?
Latest Answer: Global variable are forms specifice variable. it can store character value upto 255, for all usages. We can initialize it when we declare, otherwise give error if we did not assign it any value.Oracle 10g it can take upto 4000 bytes. ...
What do you mean by Conceptual? How its helps? Why we go for Conceptual Model?
What are the different values for :SYSTEM.MESSAGE_LEVEL and its impact?
Latest Answer: There are 25 Levels of Message in an Oracle Forms.How much cretical error or message is0 -- all errors or message12...25 -- don't shows anyIf we don't wannat show any error or message to the user then we assign 25 to message level ...
Latest Answer: Some objects are stored in the database and can be created and manipulated with SQL but are not contained in a schema. Its called non schema object. Non schema objects are given below:- Contexts Directories Parameter files (PFILEs) and server parameter ...
Design a suitable database system for a bank along with 20 possible queries to the database (the quries should be such that their solution involves subquries or joins or both). Implement the database and the queries in a commercial DBMS using SQL
Latest Answer: RAISE statement is used to raise exception explicitly with in the EXECUTABLE sectionwhere: Exception is previously declared in declaration section as 'exception'. ...
Latest Answer: select e.ename,sal from emp e where e.sal>(select avg(sal) from emp where e.deptno=deptno) ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 Next >>
Go Top
