A DML table expression clause is only useful when you need columns from more than one table. In your case, you can use a regular update with an EXISTS: If you really do need to use columns from both tables you have three options: repeat the join in the SET and the WHERE clause. This is easy to build but … Read more
I tried the following code different ways, like by taking out the while or the if, but when I put both together (if and while), I always get the error at the end… ERROR: FIXED by changing how I declared the variable “a” to: *Notice that here, the significant change is to use VARCHAR2 instead … Read more
Unquoted identifiers must begin with an alphabetic character (see rule 6 here). You’re trying to assign a value to a column with a name starting with a number 1AO00, 1AP00 etc. Without seeing the table definition for CustomersPriceGroups we don’t know if it has columns with those names. If it does then they must have been created as quoted identifiers. If … Read more
coalesce is supported in both Oracle and SQL Server and serves essentially the same function as nvl and isnull. (There are some important differences, coalesce can take an arbitrary number of arguments, and returns the first non-null one. The return type for isnull matches the type of the first argument, that is not true for coalesce, at least on SQL Server.)
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.)
There is no combination of LIKE & IN in SQL, much less in TSQL (SQL Server) or PLSQL (Oracle). Part of the reason for that is because Full Text Search (FTS) is the recommended alternative. Both Oracle and SQL Server FTS implementations support the CONTAINS keyword, but the syntax is still slightly different: Oracle: SQL … Read more
Try something like this. Replace ‘NikitaBuriak’ with the ID you used when you created the table..
Since Oracle 9i there are two ways or declaring a directory for use with UTL_FILE. The older way is to set the INIT.ORA parameter UTL_FILE_DIR. We have to restart the database for a change to take affect. The value can like any other PATH variable; it accepts wildcards. Using this approach means passing the directory … Read more
The keyword for Oracle PL/SQL is “ELSIF” ( no extra “E”), not ELSEIF (yes, confusing and stupid)
An ORA-01722 error occurs when an attempt is made to convert a character string into a number, and the string cannot be converted into a number. Without seeing your table definition, it looks like you’re trying to convert the numeric sequence at the end of your values list to a number, and the spaces that … Read more