Difference between UNION and UNION ALL
A form has master and detail block, when I query the master block, it should query only master records, not detail records and when I take the cursor in detailed block then only it should query detailed block. How will u achieve it?
How will u call a form from another form ?
Can we create 2 LOV’s on a single record Group?
What is Property Class in forms?
What are the triggers in reports?
I have created a report with a query written in it. when I run this report, if there are no records, then that report will show blank, but I want to see the text on the report….’No Data Found’, How will u achieve it?
What is the difference between CALL_FORM, OPEN_FORM and NEW_FORM?
If we create a form based on a complex view, then how will u insert, update, delete the records?
create table atest(a varchar2(20))
insert into atest values('a');
alter table atest
modify a Number;
Is it right statement?
2)
create table atest(a number,sal number)
create view atest_v as select a,sal,(sal*.1) comm from atest
insert into atest values(10,1000);
then what is the value of comm?
3)for the same q2
update emp set comm=1000 where a=10;
then what is the value of sal?
4)create table atestv as select * from atest_v;
update atest_v set sal=800 where a=10,
commit;
then what is the value of sal in the atestv?
5)create table emptest
( a number primary key) how many indexes will be created?
6)Can I update rowid?
7)CREATE OR REPLACE FUNCTION afun1 (a NUMBER)
RETURN NUMBER
IS
b NUMBER;
c number;
BEGIN
c:=a*10;
b := afun1(c);
RETURN b;
END afun1;
what is the ouput ?
Need to justify your answer?
8)CREATE OR REPLACE FUNCTION afun1 (a IN NUMBER)
RETURN NUMBER
IS
BEGIN
RETURN 10;
DBMS_OUTPUT.putline (a * 10);
END afun1;
what is the output?
9)what is sequence;
I am using sequence in emp table
ex:
insert into emp values(emp_s.nextval,'test');
if update empno is the sequence value will be incremented by the same value?
