Forum Stats

  • 3,758,925 Users
  • 2,251,475 Discussions
  • 7,870,437 Comments

Discussions

Can select COUNT(*), but cannot DESC

Liturgist
Liturgist Member Posts: 13
edited Apr 4, 2018 5:08PM in SQLcl

Why can sqlcl count records, but cannot describe the table?

sqldeveloper-17.3.1.279.0537-no-jre

java version "1.8.0_162"

DAXXXH @ ODXXXD2 >SELECT COUNT(*) FROM DIM_FCTS_CMC_CLCL_JUNK;

  COUNT(*)

----------

  12847914

Elapsed: 00:00:00.094

DAXXXH @ ODXXXD2 >DESC DIM_FCTS_CMC_CLCL_JUNK;

ERROR:

---------------------------------------------------

ERROR: object DIM_FCTS_CMC_CLCL_JUNK does not exist

Answers