--remarks :=== wU K‡i U¨ve‡jU ‡L‡Z n‡e (1 w`b)#1 Tab by mouth for 1 Days
select regexp_substr(remarks,'[^#]+',1,2)
from pm_presmedicine
will show
1 Tab by mouth for 1 Days
and
select regexp_substr(remarks,'[^#]+',1,1)
from pm_presmedicine
will show wU K‡i U¨ve‡jU ‡L‡Z n‡e (1 w`b...
BD CLOCK TIME ZONE
Time in Dhaka -
All lINK : 1. http://www.123techguru.com/types-of-controls/ Built_in sub programs used in Form Triggers . 1 commit_form used to ... -
PROCEDURE PRC_SEARCH IS V_WHERE varchar2(4000); BEGIN V_WHERE := 'COMPANY_NO=:GLOBAL.G_COMPANY_NO'; IF :CTRL_SEARCH....
-
When you install Oracle Developer Suite 10g Release 2 on windows 7 and try to open any form within the builder, you may face the following ...
-
How to Read Image File at Oracle Forms 10g ? I heard and answered lot's of question. How i read image file from file system to ...
-
বয়স সবে ত্রিশের কোটা পেরোচ্ছে। আর এরই মধ্যে খেয়াল করলেন , মাথার চুল পড়ে যেন টাক হয়ে যাচ্ছে ! ব্যাপারটা মোটেই সুখকর ... -
DECLARE cl_frm varchar2(10); begin cl_frm := GET_APPLICATION_PROPERTY(calling_form); if cl_frm='ORF_M03' THEN SET_TAB_PAG...
-
MAIN STRUCTURE TO CREATE PARAMETER: Pass Parameter from One Form to another You can easily pass parameters from one form to another fo...
-
Oracle APEX 18.1 Installation Steps oracle apex
-
How to Connect Oracle Database with Microsoft Access Database? My first post for oracle developer. when you want to try c... -
For Loop : Example : In this example used a pakage pkg_mm.prcinsitemstk <<Pakage>> <<Procedure>> PROCEDU...