Answer / orawhiz

A segment is a set of extents allocated for a certain logical
structure.

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

0 Answers   Infosys,

---

write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

7 Answers   British Telecom BT,

---

Explain oracle 12c new features for developers?

0 Answers  

---

how to retrieve data from different tables ,place this data in different excel worksheets.

1 Answers   Gap Inc,

---

What is Public Database Link ?

1 Answers  

---

What are virtual columns?

2 Answers   TCS,

---

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

---

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

2 Answers   IBM,

---

What are the different types of databases?

1 Answers  

---

What are the different type of Segments ?

2 Answers  

---

why dont we assign not null constraint as table level constraint.

0 Answers  

---

How you open and close a cursor variable.Why it is required?

2 Answers  

---