Answer / parivesh sinha

declare
x number:=1;
x1 number:=2;
y number:=3;
y1 number:=4;
begin
x := y1- y;
dbms_output.put_line (x);
x1 := y1+1 - y;
dbms_output.put_line (x1);
y := x +x1;
dbms_output.put_line (y);
y1 := x1+1 +x;
dbms_output.put_line (y1);
end;

Answer / santhi k

IN ORACLE...

SELECT DECODE(X,X,Y)X,DECODE(Y,Y,X)Y FROM TABLENAME;

How do I use google cloud in sql?

0 Answers  

---

Does view contain data?

0 Answers  

---

Why is sql*loader direct path so fast?

0 Answers  

---

what are date and time functions in mysql? : Sql dba

0 Answers  

---

How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

---

Is it possible to sort a column using a column alias?

0 Answers  

---

Is a table valued function object?

0 Answers  

---

How do you use join?

0 Answers  

---

How delete a row in sql?

0 Answers  

---

What is pl sql script?

0 Answers  

---

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

How many null values can be inserted in a coulmn whihc is unique constraint

8 Answers   Flextronics,

---