-
Can a function take OUT parameters. If not why?
No. A function has to return a value,an OUT parameter cannot return a value.
-
Difference between database triggers and form triggers?
Data base trigger(DBT) fires when a DML operation is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screenCan be row level or statement level No distinction between row level and statement level.Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as well as variables in forms.Can be fired from any...
rajakumar_na
- Nov 14th, 2007
Database Trigger: We can't invoke a Form Trigger in DatabaseFrom Trigger: We can invoke a Database Trigger in Forms
Mohit Dhamija
- Jul 3rd, 2006
Even 'Form Trigger' can be fired before and after the event. ex- Triggers like Pre Block / Pre Record / Post Block / Post Record ..
-
Where we use nested tables in our real time
Nicsmart
- Mar 31st, 2010
• Use when working with an unbounded list that needs to increase dynamically • Use when you need to store in the database and operate on elements individually
paul
- Sep 2nd, 2006
Hi,Nested Tables are collector objects (only attributes, i.e. no behaviour defined), that can be re-used in the same way as a class in java or c++ (without functions / procedures). In RDBMS...
-
-
-
Select 1 from dualunionselect 'A' from dual; I guess the query will select zero rows. Is it wrong or right ? if wrong thenWhat will be the result set for the query?Thanks in advance.
nis1981
- Aug 3rd, 2008
Inorder to use UNION SET OPERATOR the datatype and the number of columns should match. Here you are trying to get the union of a character datatype and a number, hence you get an error.
Renuka Rajput
- Jul 29th, 2006
i would like to add one more point that not only datatypes but also structure of both the select statement should be same.if we write query asselect 1,2 from dualunionselect 1 from dualit will still results in error and the error isexpression must have same datatype as corresponding expression
-
What is the difference between single quote (') and double quote(") in relates to using in SQL. When do you use 'xxx' and "xxx"? what is the difference both of them?
g_sidhu
- Feb 7th, 2008
Date and character literals must be enclosed within single quotation marks (' ');If a column alias contains a space, it should be enclosed in double quotation marks.
rampratap409
- Dec 4th, 2006
double quote(") is used to give user defined column alias example:select empno , ename "employee name" from emp;this will print column heading as: EMPNO ...
-
1. why the performance of the table is degraded when more index is created on the table......2. whats the main usage of synonym other than that of creating other names to objects....3. shall we able to create an primary index on the table which already has the null value? if yes syntax please.........4. whats the main usage of trigger.......... (eg..) please...
shravanam
- Oct 28th, 2007
1. When you create more indexes on a table , for example table A has 10 columns and you have create 8 indexes on that table. Then whenever you r going to retrieve data from that table each row o...
Sushma
- Jul 11th, 2007
3.If we have the null values in the column then we can not create primary key trigger on that column.4. It is an event that raised implicitly when you update the table.Regards,Sushma
-
How to get single entry of empname from emp table for employee taking max salary
sampra
- Mar 6th, 2012
Select salry from Hello h where 1=(select count (distinct salry) from hello where h.salry
maqsood
- Jul 10th, 2006
Select last_name from employeesWhere rownum
-
-
What is Query Analyser?
Sundaresan
- Aug 29th, 2006
Grid computing
-
What is select statement to spell out SALARY?(Query should work upto 5 million)
krishnaindia2007
- Jun 22nd, 2008
SELECT TO_CHAR(TO_DATE(11111,'J'),'JSP')||' DOLLARS' FROM DUALThis will work for the values in between 1 and 5373484 only.
-
-
May i know about ref cursor?.
krishnaindia2007
- Jun 22nd, 2008
Ref cursor is basically a data type. A variable declared based on that data type is called cursor variable. The main advantage of using this variable is we can dynamically assosiate with different queries at runtime depending upon our requirement.
tariq_oracle
- Jun 8th, 2008
1. This is a dynamic cursor which can holds multiple value at run time2. Actually this is nothing but a data type of cursor variable
-
What are cursor attributes?
%ROWCOUNT%NOTFOUND%FOUND%ISOPEN
narmadac
- Feb 11th, 2010
Cursor attributes when appended to the cursor name allow the users to access useful information from the retrieved rows. After opening a cursor a 'fetch' statement is used to fetch rows from the...
syam sundar
- Aug 17th, 2007
%ROWTYPE - returns number of the rows which are fetched/updated/deleted%ISOPEN - returns true if the cursor is open%FOUND - returns true if the cursor fetched any row%NOTFOUND-returns true if the cursor does not fetch any row
-
What is the data type of the column of Dual table?
g_sidhu
- Feb 13th, 2008
The DUAL table is owned by the user SYS and can be accessed by all users. It contains one column, DUMMY, and one row with the value X. The DUAL table is useful when you want to return a value once onl...
kowmudiswarna
- Sep 13th, 2007
Hi,The data type of column of dual table is character data type i.e varchar2
-
-
How to compare the total salary of all employee with a individual employee salary for a particular department.
sumanta.bala
- Jun 5th, 2009
SELECT ename,deptno,sal,TRUNC (AVG (sal) OVER (PARTITION BY deptno)) avg_sal FROM scott.emp
-
There is a table with Pluks(‘plk’) and Zinks (‘zin’). Each Pluk onlyresides on a single Zink and each Zink may contain multiple Pluks. Howdo you find how many Pluks are on each and every Zink? Please provide SQL.
-
How to get 1,4,7,10.....rows from a table
Arjunya
- Apr 29th, 2010
SELECT XFROM YWHERE MOD(X,3) = 1;Where X is the column name and Y is the table name.
ganne
- Aug 2nd, 2006
Select rownum,empno from emp group by rownum,empno having mod(rownum,3)=1;
Oracle SQL Interview Questions
Ans