Search results for query: *

You must logout from current user before changing the connection. Please try below code... IF (:Login_Blk.Txt_User IS NOT NULL AND :Login_Blk.Txt_Password IS NOT NULL) THEN logout; --To logout from current user before changing conn. LOGON...

message(get_application_property(operating_system)); Returns the name of the operating system that is currently in use. Valid return values are MSWINDOWS, MSWINDOWS32, WIN32COMMON, UNIX, SunOS, MACINTOSH, VMS, and HP-UX. Regards Shahzad Zafar

have u COMPILED and REGENERATE the report after the change u have made. Compile:- PROGRAM-->COMPILE-->ALL (ctl+shift+k) Generate:- FILE-->ADMINISTRATION-->COMPILE REPORT (ctl+T) Regards Shahzad Zafar

hi rloiben, You can use this statement for six months before.... where date>add_months(sysdate,-6) .............it will be always accurate Regards Shahzad Zafar

hi, please try to use folloeing query..... select * from (select * from scott.emp order by dbms_random.random) where rownum<10 Regards Shahzad Zafar

hi adeel, adeel u can convert tabular form values into excel sheet by using UTL_FILE package.but by using this package u will use the cursor to put values into excel sheet. The following link is usable for u ..pl try... http://www.experts-exchange.com/Databases/Oracle/Q_20410995.html Thanx...

hi anniez, please use following update statment may be your problem will solve....... in case no please explain your question more and describe the structure of both tables ... update tab_a a set a.group=(select substr(b.grp_dept,1,3) from tab_b b where...

hi kido, You can convert your application from 6i to 9iAs easily... 1-Put all your fmx files in <orahome>\forms90 folder. 2-Compile all your forms in 9iAS. 3-run the form on browser. OR 1-put the path of your application in <orahome>\forms90\server\formsweb file change ---1...

hi avinashhegde, Simply set Parameter of report to FILE and named <filename>.HTML.,report will save in excell sheet instead of screen. Regards Shahzad Zafar

hi jimmy, when u r calling a stored procedure in pl/sql block then there is no need of EXECUTE command ,it is used at that time when u execute a SP on sql propmt. Simply use..... begin test_procedure('param1','param2'); end; Thanks.. Regards Shahzad Zafar

hi prosuc, You should query the required field from table before updation if it already contains value then update it with previous retrieved value else null means new value .u can add this code in your when_button_pressed trigger, suggested is to use this code in PRE_UPDATE trigger . This code...