Questions[oracle]

In an Oracle database, I have a table with a field defined as varchar(2), in which I must enter a code (key of the table), but when entering the code 'LÑ' it returns an error, I have used Ñ in another field in the same table.

The table only has these two fields (In the DESCRIPTION field, if I can enter Ñ):

"PROFESSIONID" VARCHAR2(2), 
"DESCRIPTION" VARCHAR2(200), 

I do the insertion with this code

INSERT INTO ESQUEMA.TABLA (PROFESSIONID,DESCRIPTION) VALUES ('LÑ','ESTA ES LA DESCRIPCION');

The error it returns is the following.

SQL Error [12899] [72000]: ORA-12899: el valor es demasiado grande para la columna "ESQUEMA"."TABLA"."PROFESSIONID" (real: 3, máximo: 2)

How can I solve that? And why does this error occur?

It is difficult for me to write a query that based on the table that I show below, I selected the most recent date for the repeated products.

categoria    / Id_liente  / Producto  / Fecha
Limpieza    /  1          /  Lejia    / 20-02-2018
Limpieza    /  1          / Lejia     / 31-12-2019
Alimentacion/  1          / Vino      / 20-12-2019

After executing the query it would be:

categoria    / Id_liente  / Producto  / Fecha
Limpieza    /  1          / Lejia     / 31-12-2019
Alimentacion/  1          / Vino      / 20-12-2019

In ORACLE I have used Max(Fecha)and GROUP BYbut it returns (logically) the last transaction made for each client.

SELECT *
FROM (
    SELECT CATEGORIA,ID_CLIENTE, PRODUCTO, MAX(FECHA) FECHA
                            FROM VENTAS
                            GROUP BY CATEGORIA, ID_CLIENTE, PRODUCTO
)

(With code similar to what I've seen in SQL Query grouping and with latest date )

I'm having a hard time seeing how I can make SQL only apply MAX(Fecha)for each type of product and customer.

Could someone guide me to perform the query in ORACLE? a greeting.

How can I pass this queryto Oracle?, I'm updating a field from table A through inner jointable B:

UPDATE ATA
SET A.ID_IN = B.id_in
FROM TMP_TRF_ALL ATA
INNER JOIN items B
on ATA.seq=B.seq
WHERE ATA.PROCESADO = 1
AND  ATA.EXT = '213'
AND B.ID_COMPANY='1'

I have done this, but it is not correct because it does not update and it is as if I wanted to update the field ID_INof the table items, when in fact I want to update the field ID_INof the tableTMP_TRF_ALL

UPDATE 
(SELECT ATA.id_in as T1IV,B.id_in AS T2IV FROM TMP_TRF_ALL ATA  INNER JOIN items B 
on ATA.seq=B.seq 
WHERE ATA.PROCESADO = 1 AND  ATA.EXT = '213' AND B.ID_COMPANY='1')T
SET T.T1IV=T.T2IV

I am trying to insert records into a table TB_DET_SUSCRIPCION_DOCbut SELECTit returns more than one record.

the error is the following.

Bug report: SQL Error: ORA-01427: single-row subquery returns more than one row 01427. 00000 - "single-row subquery returns more than one row"

The query:

INSERT INTO cuentas.TB_DET_SUSCRIPCION_DOC (id_det_suscripcion_doc, id_suscripcion_doc, id_tip_producto, rango_envio) 
VALUES (SQ_DET_SUSCRIPCION_DOC.NextVal,(SELECT cuentas.tb_suscripcion_doc.id_suscripcion_doc 
FROM cuentas.TB_SUSCRIPCION_DOC WHERE TRUNC(fec_inicio_envio,'DD') BETWEEN to_date('01-07-2016', 'DD-MM-YYYY') AND to_date('31-07-2016', 'DD-MM-YYYY') 
AND cuentas.tb_suscripcion_doc.id_tip_doc_susc = 23 
AND cuentas.tb_suscripcion_doc.fec_termino_envio is null), 0,0);

Has anyone had that problem? can you tell me how to solve it?

I need to replace a particular character from each in oracle.

For example:

cadena= '12121113'

and what I need is to change the "1" to a "2" but only the "1" that is in position 3.

and return me the modified result.

As a result it should remain '12221113'.

I hope I have explained myself well.