Answer Posted / ajay

Yes, it is possible here are the examples

create or replace function funbool(b varchar2)
return boolean
as
begin
If b is not null then
return true;
else
return false;
end if;
end;

create or replace function funbool(b varchar2)
return number
is
begin
if b is null then
Dbms_output.put_line( 'false');
else
Dbms_output.put_line( 'true');
end if;
Return b;
end;

Explain entity ?

1019

---

5. Explain about relational algebra.

2172

---

How do you pass parameter in stored procedure?

1203

---

can we delete autodiff back up that we have set through sql server agent.

2195

---

How do I manually create a database?

1180

---

How to do Stored procedure testing? Who does this testing (Developer or tester)?

1810

---

Is hive a database?

940

---

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

1113

---

What does currency type mean in database?

1191

---

What are the most common databases?

971

---

Differentiate between extension & intension?

1422

---

What is the best database?

982

---

wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

3085

---

what is rcp,if rcp disabled what happen?

2215

---

Explain entity type?

988

---