You are exceeding the SQL limit of 4000 bytes which applies to LISTAGG as well. As a workaround, you could use XMLAGG. For example, If you want to concatenate multiple columns which itself have 4000 bytes, then you can concatenate the XMLAGG output of each column to avoid the SQL limit of 4000 bytes. For example,
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?
Try to execute this first ,and check whether anyone from other session or your session put a lock on that table .If you have put a lock on that table,try to do commit/rollback .If someone else put a lock ,ask him/her or if you have rights kill his session .And then drop the table.
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.:
The user and password are DEFINITELY incorrect. Oracle 11g credentials are case sensitive. Try ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE; and alter password. http://oracle-base.com/articles/11g/case-sensitive-passwords-11gr1.php
I had this issue and the fix was to make sure in tnsnames.ora the SERVICE_NAME is a valid service name in your database. To find out valid service names, you can use the following query in oracle: Once I updated tnsnames.ora to: then I ran: Success! The listener is basically telling you that whatever service_name … Read more
If you have a numeric column, all you have to do is use a to_char with the right parameters; this should do the work: