How to find the date and time of last updated table?
Answer Posted / aseem k
select b.name, a.analyzetime from tab$ a, obj$ b
where a.obj#=b.obj#
and b.name ='EMP'
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use subqueries in the from clause in oracle?
How to define an explicit cursor in oracle?
How to list all tables in your schema?
What do you mean by redo log file mirroring?
Explain oracle’s system global area (sga).
Is java required for oracle client?
How to empty your oracle recycle bin?
How to invoke the original export import utilities?
What is analyze command used for?
What is system global area (sga) in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is oracle datasource?
How to create a stored function in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to define a variable of a specific record type?