Answer Posted / arijitnit

update table_name set column_name=value where condition

What is PL/SQL ?

1112

---

What is ceil and floor in oracle?

574

---

What is a parameter file in oracle?

560

---

Explain oracle data types with examples?

575

---

What is oracle latest version?

579

---

---

Explain about functional dependency and its relation with table design?

550

---

How to use "in out" parameter properly?

612

---

What is truncate oracle?

529

---

When system tablespace is created?

605

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1179

---

How to define a data source name (dsn) in odbc manager?

527

---

What is user managed backup in Oracle?

612

---

How many types of auditing in Oracle?

566

---

What are named parameters?

612

---

How to define an oracle cursor variable?

566

---