Answer Posted / manoj

select table_name, to_char(last_analyzed, 'DD-MM-YY
HH:MI:SS') from user_tables where last_analyzed in (select
max(last_analyzed) from user_tables)

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2145

---

How to use "startup" command to start default instance?

962

---

What is data type in oracle?

1039

---

How to run the anonymous block again?

1065

---

How to declare a local variable?

1051

---

How to do clean up if create database failed?

973

---

What are the differences between char and nchar in oracle?

1020

---

How to call a sub procedure?

1034

---

What is integrity and what is constraint??Explain with example

2213

---

What are the arithmetic operations?

1023

---

What are the oracle built-in data types?

1008

---

What is index-organized table in Oracle?

1018

---

How to create a new oracle data file?

969

---

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

953

---

What are the restrictions on external table columns?

990

---