Answer Posted / sangeetha

create or replace procedure <pocedure_name>(x in number,y
out varchar) is begin
{
executable statements;

}
end <procedure_name>;

exec <procedure_name>(first_parameter,second_parameter);

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

1728

---

What is %s in sql?

570

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

673

---

Can we insert in sql function?

551

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

557

---

---

How do you remove duplicates without using distinct in sql?

506

---

What is difference between inner join and cross join?

522

---

What is application trigger?

545

---

What is a sql profiler?

592

---

How to display Row Number with Records in Oracle SQL Plus?

594

---

How do you explain an index?

792

---

Is progress software supports to ( pl/sql )?

532

---

describe mysql connection using mysql binary. : Sql dba

552

---

What is an exception in pl/sql?

544

---

What is an invalid partition table?

566

---