Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Can i possible to see Table Details ?
Ex :
Table Name Date Time User
Emp May/18/2010 12:59pm Scott

Question Posted / meerjasa.s

Answers were Sorted based on User's Feedback



Can i possible to see Table Details ? Ex : Table Name Date Time User Emp ..

Answer / saraswathi muthuraman

SELECT OWNER,OBJECT_NAME,To_char(CREATED,'MON//DD/YYYY'),
to_char(CREATED,'HH:MM PM') from ALL_OBJECTS WHERE
OBJECT_TYPE ='TABLE' AND OBJECT_NAME ='EMP_TEST';

Result:

Saras EMP_TEST
JUN//01/2010 11:06 AM

Is This Answer Correct ?    6 Yes 0 No

Can i possible to see Table Details ? Ex : Table Name Date Time User Emp ..

Answer / kamal

SELECT OWNER,OBJECT_NAME,TRUNC(CREATED),TIMESTAMP FROM
DBA_OBJECTS WHERE OBJECT_TYPE ='TABLE' AND OBJECT_NAME
='EMP'

Is This Answer Correct ?    4 Yes 0 No

Can i possible to see Table Details ? Ex : Table Name Date Time User Emp ..

Answer / prash

yes

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Explain the uses of a database trigger?

0 Answers  

How many triggers can be applied to a table?

0 Answers  

What is diff between bulk collect and forall

3 Answers   Metric Stream,

what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,

What is using in sql?

0 Answers  

How to get second highest salary from a table

3 Answers  

How do I run a sql query?

0 Answers  

what is self join and how it works??

2 Answers   Infosys,

How will we see framework of a table?

2 Answers   Accenture,

What is the primary use of normalization?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories