You are here:

Oracle/Diff between TAB and TABS in Oracle

Advertisement


NT wrote at 2011-02-14 16:52:35
TAB - gives you the details on the Object name & object type created only.



TABS - gives you all the details of a table, like the space used, if it was analysed, # of blocks used, PCT details. Basically EVERYTHING for a Table.


Gulab wrote at 2013-05-20 09:57:49
Hi Friends,

I think TAB AND TABS BOTH are SHOWING TOTAL TABLES NAMES.



IN TAB NOTE SHOW MORE DETAIL ABOUT TABLE BUT IN TABS SHOW MORE DETAIL ABOUT TABLE.

Eg. select * from tab

   select * from tabs


Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Suchitra Joshi

Expertise

I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.

Experience

15+ years of Oracle PL/SQL Development

Education/Credentials
B.Sc (Electronics), Diploma in Computer Applications (DCA)

Awards and Honors
Oracle PL/SQL Developer Certified Associate (OCA)
Oracle Database: SQL Certified Expert
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

©2016 About.com. All rights reserved.