you’ve used double quotes on “X”. this should be ‘X’. the X object is an function in the MDSYS schema, “ogc_x”, so when you say est.tipo_estatus = “X” instead of the correct est.tipo_estatus = ‘X’ it gets translated (as “” is as an identifier so “X” is the same as just typing X) to est.tipo_estatus = mdsys.ogc_x and of course fails.
This works on functions, procedures, packages, types, synonyms, trigger and views. Update: After updating the post for the third time, I’ll reformulate this: This does not work on tables 🙂 And yes, there is documentation on this syntax, and there are no REPLACE option for CREATE TABLE.
In oracle, generally speaking, there are number of facts that I will mention in following section: Each database can have many Schema/User (Logical division). Each database can have many tablespaces (Logical division). A schema is the set of objects (tables, indexes, views, etc) that belong to a user. In Oracle, a user can be considered … Read more
Execute is sql*plus syntax .. try wrapping your call in begin .. end like this: (Although Jeffrey says this doesn’t work in APEX .. but you’re trying to get this to run in SQLDeveloper .. try the ‘Run’ menu there.)
How can I insert into table with different input using / ,with date datatype? I’m using oracle 10g.
When I try to execute this snippet: I get: There is no problem with database connection because I can execute basic SQL commands. What is the problem with this statement?
Remove the comma? Have a look at FROM SELECTING from multiple tables You can include multiple tables in the FROM clause by listing the tables with a comma in between each table name
Replace double quotes with single ones: In SQL, double quotes are used to mark identifiers, not string constants.