0

I created a dummy table and added some dummy values into the table. However, when I do - DESCRIBE <table name here>;, none of the values that I have entered are displayed.

For reference if needed, here's the code below:

CREATE TABLE EMP(
    EMPNO    NUMBER(4) NOT NULL,
    ENAME    VARCHAR2(10),
    JOB      VARCHAR2(9),
    MGR      NUMBER(4),
    HIREDATE DATE,
    SAL      NUMBER(7, 2),
    COMM     NUMBER(7, 2),
    DEPTNO   NUMBER(2)
); 

<table created>

INSERT INTO EMP VALUES (7369, 'SMITH', 'CLERK',    7902, TO_DATE('17-DEC-1980', 'DD-MON-YYYY'), 800, NULL, 20);

<1 row created>

https://i.stack.imgur.com/oOQWK.jpg (what happens when I describe the table after entering the values)

Nisse Engström
  • 4,738
  • 23
  • 27
  • 42

1 Answers1

0

DESCRIBE is a DDL utility statement used to view information about the column definitions in a table.

Use a DML statement like SELECT to actually query the data:

SELECT * FROM EMP
Community
  • 1
  • 1
Marcus Adams
  • 53,009
  • 9
  • 91
  • 143