sql - A table still exists when dropped -

when used command worked, means table dropped

drop table <table name> ; 

but when query

sql>select * tab; 

my dropped tables not showing. other tables bin$+np+vhp7rf2hlc1aojf+gg==$0 are.

how drop type of table?

you're using recent version of oracle , table has been placed in recyclebin. rid of in first instance can use

drop table <table_name> purge; 

to quote the documentation on drop table:

specify purge if want drop table , release space associated in single step. if specify purge, database not place table , dependent objects recycle bin.
...
using clause equivalent first dropping table , purging recycle bin. clause lets save 1 step in process. provides enhanced security if want prevent sensitive material appearing in recycle bin.

the recyclebin can come in handy though... it's additional back-up when you've accidentally dropped wrong table. if specify purge when dropping table you'll never able retrieve table recyclebin. note, however, if drop without purging space used object not freed.

to remove table recyclebin use:

purge table "bin$+np+vhp7rf2hlc1aojf+gg==$0"; 

note object name cased need double quotes.