Home / Questions / 536131
Accepted
Henriquez10
Asked: 2022-07-24 20:15:34 +0800 CST 2022-07-24 20:15:34 +0800 CST

How to remove characters from a string using PLSQL?

  • 772

I am storing a file in a temporary table.

 Declare 
    l_nombre_archivo = varchar2(300);    
    
   Begin

          select filename
             INTO   l_nombre_archivo
          FROM apex_application_temp_files              
          where name = :P200_FILE; ---Es el file browser

          :P200_FILENAME := l_nombre_archivo;  ---:P200_FILENAME es el label

   End;

Then I print the filename in a label and it looks like this: myfile.txt

How can I remove the .txt characters?

Expected result print only: myfile

plsql

1 Answers

  1. Best Answer

    You can use the INSTR and SUBSTR functions , for example:

    select substr(filename,1,instr(filename,'.')-1)
             INTO   l_nombre_archivo
          FROM apex_application_temp_files              
          where name = :P200_FILE;
    • 1