I am getting the above error when trying to connect to a server database from a client using service name orcl. It is getting connected when I am using the other service name i.e. dms Below is my listener.ora Please tell me what to do?
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
You need to set oracle to listen on all ip addresses (by default, it listens only to localhost connections.) Step 1 – Edit listener.ora This file is located in: Windows: %ORACLE_HOME%\network\admin\listener.ora. Linux: $ORACLE_HOME/network/admin/listener.ora Replace localhost with 0.0.0.0 Step 2 – Restart Oracle services Windows: WinKey + rservices.msc Linux (CentOs):sudo systemctl restart oracle-xe
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 ;.
o to the windows machine that hosts the Oracle database server Go to Start -> Run -> Services.msc in Windows. Locate OracleService < SID > (here OracleServiceORCL) and click on Start to start the oracle database service (if not already running) Once it is up and running, from the command prompt run the following:tnsping < tnsalias > (tnsalias entry you can … Read more
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
Assuming that create_time contains the time the order was created, and you want the 100 clients with the latest orders, you can: add the create_time in your innermost query order the results of your outer query by the create_time desc add an outermost query that filters the first 100 rows using ROWNUM Query: UPDATE for Oracle 12c … Read more
Short answer: Yes, it can be NULL or duplicate. I want to explain why a foreign key might need to be null or might need to be unique or not unique. First remember a Foreign key simply requires that the value in that field must exist first in a different table (the parent table). That … 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
You’ll need to put your current query in subquery as below : Oracle applies rownum to the result after it has been returned.You need to filter the result after it has been returned, so a subquery is required. You can also use RANK() function to get Top-N results. For performance try using NOT EXISTS in place of NOT IN. See this for more.