hello beter,
basically if you want to add single code to any string you can use :

/' "any string you want here" /'

and if you want to use it inside sql statement hence you are building VO at run time (onthefly :)) so you can write :

SELECT column1 FROM table WHERE column2 = + "'"+ Vstr+"'";

where Vstr is your String variable in your example.
 
hope this helpful 🙂
share today to gain tomorrow.

hi there,

starting from oracle 8i we are eligible to send emails directly from PL/SQL by using either UTL_SMTP or UTL_TCP packages. However, oracle provides us valuable package called UTL_MAIL for sending emails in Oracle 10g.

here is example of how to use UTL_MAIL to send emails from PL/SQL :

BEGIN
  EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server = ''127.0.0.1''';
  UTL_MAIL.send(sender => '[email protected]',
            recipients => '[email protected]',
               subject => 'Test Mail',
               message => 'Hello World',
             mime_type => 'text; charset=us-ascii');
END;

Note : for security purpose, UTL_MAIL is not enabled by default. so you should enable it by connecting to SYS user and executing the utlmail.sql and prvtmail.plb scripts in the $ORACLE_HOME/RDBMS/admin directory. In addition, you must configure an initialization parameter, SMTP_OUT_SERVER, to point to an outgoing SMTP server.
in addition, you must give EXECUTE permission to PUBLIC by run below script :

grant execute on UTL_MAIL to public

hope this helpful 🙂
share with others to stretch our experiences

FNDLOAD command for downloading personalization in form :

FNDLOAD user/pass 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct PO_POXSCERQ_PERSONALIZ.ldt FND_FORM_CUSTOM_RULES function_name="PO_POXSCERQ"

user : this your instance user name
pass : this your instance password
PO_POXSCERQ_PERSONALIZ.ldt : this generated file after download rename appropriate name
PO_POXSCERQ : this function name which you want to download all personalization from.

just after you run above command LDT file will generated in home directory just take this LDT file and copy it to another home instance then

FNDLOAD command for uploading personalization in form :

FNDLOAD user/pass 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct PO_POXSCERQ_PERSONALIZ.ldt

hope this helpful 🙂

There is no combination of LIKE & IN in SQL, but you can use REGEXP_LIKE condition it’s similar LIKE condition, except REGEXP_LIKE performs regular expression matching instead of the simple pattern matching performed by LIKE. Also this condition evaluates strings using characters as defined by input character set.
Example 1 :

select first_name from employees where regexp_like (first_name,'^Walker|Ken|^Mr')

First Name

Walker, Mr. Kenneth (Ken)

Example 2 :

SELECT first_name
FROM employees
WHERE REGEXP_LIKE (first_name, '^Ste(v|ph)en$');

FIRST_NAME

Steven

Stephen

Example 3 :

SELECT last_name
FROM employees
WHERE REGEXP_LIKE (last_name, '([aeiou])1', 'i');

LAST_NAME

De Haan

Greene

Bloom

Feeney