Hi. Im learning databases at Uni and dont know terribly much. One thing I would like help with is in Oracle SQL developer, i decided to delete a few tables by right clicking on them and clicking drop rather than type in the SQL statement.
Now when I do a "select * from cat;".. those tables that I dropped are now replaced with other tables called names such as "BIN$NnPpas9KYDTgRAADuk3XZA==$0".. but they will not drop as it says SQL command not properly entered.
Can someone help me remove these tables?
Many thanks
Now when I do a "select * from cat;".. those tables that I dropped are now replaced with other tables called names such as "BIN$NnPpas9KYDTgRAADuk3XZA==$0".. but they will not drop as it says SQL command not properly entered.
Can someone help me remove these tables?
Many thanks