Answer Posted / ns

select to_char(systimestamp,'HH24:MM:SS') from dual;

Explain what are the advantages of views?

1046

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2354

---

What are the differences between date and timestamp in oracle?

1027

---

How to speed up webrick?

1050

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4327

---

Explain the difference between replace() and translate() functions in oracle?

1016

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2806

---

What are the roles of dba?

1050

---

Explain the use of grant option in imp command.

996

---

What is the maximum number of triggers that can be applied to a single table?

1001

---

How to specify default values in insert statement using oracle?

1082

---

Why we use bulk collect in oracle?

1011

---

Can we convert a date to char in oracle and if so, what would be the syntax?

991

---

How to get last row id?

970

---

How to create an oracle database manually?

1057

---