At line 5 there is a / missing. There is a good answer on the differences between ; and / here. Basically, when running a CREATE block via script, you need to use / to let SQLPlus know when the block ends, since a PL/SQL block can contain many instances of ;.
This is usually caused by duplicates in the query specified in USING clause. This probably means that TABLE_A is a parent table and the same ROWID is returned several times. You could quickly solve the problem by using a DISTINCT in your query (in fact, if ‘Y’ is a constant value you don’t even need … Read more
The error message will include the name of the constraint that was violated (there may be more than one unique constraint on a table). You can use that constraint name to identify the column(s) that the unique constraint is declared on Once you know what column(s) are affected, you can compare the data you’re trying … Read more
When creating the TABLE under B2BOWNER, be sure to prefix the PL/SQL function with the Schema name; i.e. B2BOWNER.F_SSC_Page_Map_Insert. I did not realize this until the DBAs pointed it out. I could have created the table under my root USER/SCHEMA and the PL/SQL function would have worked fine.
Well the problem simply-put is that the SUM(TIME) for a specific SSN on your query is a single value, so it’s objecting to MAX as it makes no sense (The maximum of a single value is meaningless). Not sure what SQL database server you’re using but I suspect you want a query more like this … Read more
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
Your table is already locked by some query. For example, you may have executed “select for update” and have not yet committed/rollbacked and fired another select query. Do a commit/rollback before executing your query.
Replace double quotes with single ones: In SQL, double quotes are used to mark identifiers, not string constants.
I use SQL developer and i made a connection to my database with the system user, after I created a user and made a another connection with that user with all needed privileges. But when I try to proceed following I get the SQL Error ORA-00942 table or view does not exist.:
I deleted the ojdbc14.jar file and used ojdbc6.jar instead and it worked for me