problem in sql query

Question

I have a query

INSERT INTO NEW_TABLE
  (No_COUNT)
VALUES 
(SELECT COUNT(*) 
  FROM TABLE2)

On executing in am getting

ORA-00936: missing expression error.

Any idea why above query showing error?

Answer 1

INSERT INTO NEW_TABLE
(
    No_COUNT
)
SELECT 
    COUNT(*) 
FROM 
    TABLE2;