Videos uploaded by user “Together Oracle”
How to Run any Browser Oracle FORMS 10g On Internet Explorer | Ten Minute Code
Developer : Md. Quium Hossain (IDB) Below Code Install 1- install jini C:\DevSuiteHome_2\jinit\jinit.exe (jinit.exe is install but not need because jpi format run it ) =================Internet Explorer===================== http://www.oracle.com/technetwork/java/javase/downloads/java-archive-downloads-javase6-419409.html Previously Install Internet Explorer 11 java version jre-6u45-windows-i586.exe Flow 5 Steps Edited : = DevSuiteHome_2\forms\server\FORMSWEB.CFG 1 # System parameter: default base HTML file baseHTML=base.htm (change to) baseHTML=basejpi.htm 2 # System parameter: base HTML file for use with JInitiator client baseHTMLjinitiator=basejini.htm (change to) baseHTMLjinitiator=basejpi.htm 3 # System parameter: base HTML file for use with Sun’s Java Plug-In baseHTMLjpi=basejpi.htm 4# jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_06/index.html (change to) jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_45/index.html 5# jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06 (change to) jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_45 Any Browser Same Change ------1------ Set plugins ------2----- Set Browser ::::remember:::: # before Sign means this line not work without # means this line work
Views: 7298 Together Oracle
Create EXCEL/PDF/html/etc Report from Oracle | Ten Minute Code
BELOW CODE cerate report server below commands windows key+R run paste -- rwserver server=showjobs status=on Declare repid REPORT_OBJECT; v_rep VARCHAR2(1000); rep_status VARCHAR2(20); PL_ID PARAMLIST; pr_nm varchar2(20):='PNM'; --rwserver server=SHOWJOBS EXCECUTE IT ON RUN v_rptserver varchar2(10):='SHOWJOBS'; ---- Change 1 v_host varchar2(20):='localhost'; ---- Change 2 -- v_rptserver varchar2(10):=:global.RWS1; -- v_host varchar2(20):=:global.IP1; BEGIN PL_ID := GET_PARAMETER_LIST(pr_nm); IF ID_NULL(PL_ID) = FALSE THEN DESTROY_PARAMETER_LIST(PL_ID); PL_ID := CREATE_PARAMETER_LIST(pr_nm); IF ID_NULL(PL_ID) THEN MESSAGE('ERROR CREATING PARAMETER LIST '||pr_nm); RAISE FORM_TRIGGER_FAILURE; END IF; ELSE PL_ID := CREATE_PARAMETER_LIST(pr_nm); END IF; --add parameter with separate statement for each parameter Add_Parameter(pl_id,'P_ECode',TEXT_PARAMETER,:P_ECode); ---change 3 your report have parameters Add_Parameter(pl_id,'P_ECode',TEXT_PARAMETER,:P_ECode); repid := find_report_object('DESG'); --- change 4 report name SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF'); -- change 5 pdf/html -- SET_report_object_property(repid,REPORT_DESFORMAT,:BLOCK3.REP_FORMAT); ------ need all format SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,v_rptserver); v_rep := RUN_REPORT_OBJECT(repid,PL_ID); rep_status := REPORT_OBJECT_STATUS(v_rep); IF rep_status = 'FINISHED' THEN WEB.SHOW_DOCUMENT('http://'||v_host||':8889/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server='||v_rptserver,'_blank'); ELSE message('Error when running report'); END IF; END;
Views: 6353 Together Oracle
add new column in oracle forms 10g | Ten Minute Code
add new column in oracle forms builder 10g 1. Create table CREATE TABLE add_column (id NUMBER, Name VARCHAR2(20)); 2. Create forms 3. Add new column sql*plus ALTER TABLE add_column ADD gender VARCHAR2(10); 4. Go to form 5. Go to data block wizard table refreshapply 6. Frame select go to Layout wizard data blockapply
Views: 2101 Together Oracle
icon button oracle forms 10g | Ten Minute Code
set 10g forms icon easy way 1. paste icon to C:\Oracle\DevSuiteHome_1\forms\java folder ---only gif ions 2. C:\Oracle\DevSuiteHome_1\forms\server\formsweb.cfg change imageBase=DocumentBase to imageBase=codebase 3. go to forms set button icon yes button name null button icon print.gif 4. restart oc4j if not view 5. run your forms view icon
Views: 386 Together Oracle
oracle to ms excel using forms 6i | Ten Minute Code
Below Code declare application ole2.obj_type; workbooks ole2.obj_type; workbook ole2.obj_type; worksheets ole2.obj_type; worksheet ole2.obj_type; cell ole2.obj_type; arglist ole2.list_type; row_num number; col_num number; fontObj ole2.obj_type; cursor rec is select emp_id,emp_nm,to_char(join_dt,'dd/mm/rrrr') date_of_birth from emp_mast where join_dt is not null; procedure SetCellValue(rowid number,colid number,cellValue varchar) is begin arglist := ole2.create_arglist; ole2.add_arg(arglist,rowid); ole2.add_arg(arglist,colid); cell:= ole2.get_obj_property(worksheet,'Cells',arglist); fontObj := ole2.get_obj_property(cell,'Font'); ole2.destroy_arglist(arglist); ole2.set_property(cell,'value',cellValue); ole2.set_property(fontObj,'Size',16); ole2.set_property(fontObj,'BOLD',1); ole2.set_property(fontObj,'ColorIndex',7); ole2.release_obj(cell); end SetCellValue; procedure app_init is begin application := ole2.create_obj('Excel.Application'); ole2.set_property(application,'Visible',true); workbooks := ole2.get_obj_property(application,'workbooks'); workbook := ole2.invoke_obj(workbooks,'add'); worksheets := ole2.get_obj_property(application,'worksheets'); worksheet := ole2.invoke_obj(worksheets,'add'); ole2.set_property(worksheet,'Name','Emp Sheet'); end app_init; procedure save_excel(path varchar,filename varchar) is begin OLE2.Release_Obj(worksheet); OLE2.Release_Obj(worksheets); -- Save the Excel file created If path is not null then Arglist := OLE2.Create_Arglist; OLE2.Add_Arg(Arglist,path||'\'||file_name||'.xls'); OLE2.Invoke(workbook, 'SaveAs', Arglist); OLE2.Destroy_Arglist(Arglist); end if; end save_excel; begin app_init; row_num:=1; col_num:=1; SetCellValue(row_num,col_num,'Emp Code'); col_num:=col_num + 1; SetCellValue(row_num,col_num,'Emp Name'); col_num:=col_num + 1; SetCellValue(row_num,col_num,'Date of Birth'); for i in rec loop row_num:=row_num + 1; col_num:=1; SetCellValue(row_num,col_num,i.emp_id); col_num:=2; SetCellValue(row_num,col_num,i.emp_nm); col_num:=3; SetCellValue(row_num,col_num,i.date_of_birth); end loop; save_excel('d:\excel_export','emp_data'); OLE2.Release_Obj(workbook); OLE2.Release_Obj(workbooks); OLE2.Release_Obj(application); end;
Views: 2378 Together Oracle
FRM: 92101 There was a Failure in the Forms Server During Startup | Ten Minute Code
Step by Step Solution 1. Forms Server restart & run forms builder 2. Restart OC4J & run forms builder 3. Recompile Forms fmb file which is problem 4. Recompile menu mmb file in oracle which is problem 5. Restart your your server 6. Finally above video process InshaAllah, at last solved your problem
Views: 3743 Together Oracle
create java calendar in oracle forms 10g | Ten Minute Code
Below Code Set CALENDAR in Oracle’ forms & Show SYSDATE at run time. 1.create table : Create table add_date (Id number, Start_date date); 2.create forms 3. Calendar.jar set in java- D:\DevSuiteHome_2\forms\java\calander.jar 4. Set formsweb.config- D:\DevSuiteHome_2\forms\server find- archive 5. Create FUNCTION In the program unit FUNCTION Quium_function RETURN date IS hBeanEventDetails ParamList; eventName varchar2(80); paramType number; eventType varchar2(80); newDateVal varchar2(80); newDate date := null; begin hBeanEventDetails := get_parameter_list(:system.custom_item_e¬vent_parameters); eventName := :system.custom_item_event; if(eventName = 'DateChange') then get_parameter_attr(hBeanEventDetails, 'DateValue', ParamType, newDateVal); newDate := to_date(newDateVal,'DD.MM.RRRR'); -- else -- MsgBox.show(MsgBox.STOP_ALERT,'Uknown event received - ' || eventName); end if; return newDate; end; 6 Create When-custom-item-event in bean trigger declare newdate date; begin newdate := Quium_function; if (newdate is not null) then :ORDERS.ORDER_DATE:= newdate; end if; end; 7. Write Property palates in bean area Implementation Class: oracle.forms.demos.CalendarWidgetWrapper
Views: 4206 Together Oracle
center the forms window in oracle forms 10g 11g | Ten Minute Code
Declare v_window varchar2(100):='WINDOW1'; v_width number(4); v_height number(4); vw number(4); vh number(4); BEGIN SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,WINDOW_STATE,MAXIMIZE); SET_WINDOW_PROPERTY('WINDOW1',WINDOW_STATE,MAXIMIZE); set_window_property(forms_mdi_window,title,'ABC LIMITED BARANDING MATERIALS MANAGEMENT SYSTEM'); vw:=gET_application_PROPERTY(DISPLAY_WIDTH)-50; vh :=gET_application_PROPERTY(DISPLAY_HEIGHT)-180; v_width := Get_Window_Property(v_WINDOW, WIDTH); v_height:= Get_Window_Property(v_WINDOW, HEIGHT); Set_Window_Property(v_WINDOW, POSITION, (vw-v_width)/2, (vh-v_height)/2) ; /* SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,WINDOW_STATE,MAXIMIZE); SET_WINDOW_PROPERTY('WINDOW1',WINDOW_STATE,MAXIMIZE); set_window_property(forms_mdi_window,title,:global.COMP_MODULE); SET_ITEM_PROPERTY('CON.CUT_BTN',ENABLED,PROPERTY_FALSE); SET_ITEM_PROPERTY('CON.COPY_BTN',ENABLED,PROPERTY_FALSE); SET_ITEM_PROPERTY('CON.CQUERY_BTN',ENABLED,PROPERTY_FALSE); */ END;
Views: 402 Together Oracle
Solved cannot create save file afiedt.buf  Permanent | sp2-0110 | Afiedt.buf | Ten Minute Code
Below Guide Line ================ SQL*PLUS give have ALL Administrative Privileges Your PC | Laptop have two User Such as First One : Administrator Others Uesr : THERS User Then Problem is Created , You Solved your Problem above way ...
Views: 96 Together Oracle
install MySql | Ten Minute Code
Views: 3852 Together Oracle
REP: 0118 unable to create temporary file in Oracle Reports | Ten minute Code
C:\Users\ADMINI~1\AppData\Local\Temp C:\Users\Administrator\AppData\Local\Temp
Views: 2503 Together Oracle
create pdf to vce for vendor exam all | Ten minute Code
Exam Formatter https://www.examcollection.com/examformatter.html & Download VCE Software http://www.download82.com/download/windows/vce-exam-simulator/
Views: 265 Together Oracle
work function keys on oracle forms 10g | FRM-41008 | Ten minute Code
Below Guide 1. C:\FRHome_1\forms\frmweb.res to rename C:\FRHome_1\forms\frmweb_renm6ito10g.res ---not need but rename 2. C:\FRHome_1\forms\frmpcweb.res to rename C:\FRHome_1\forms\frmweb.res ---stop oc4j ---run oc4j work successfully press F9 for list of values
Views: 441 Together Oracle
create oracle database form oracle dbca | Ten Minute Code
below Code 1. Create Oracle Database using DBCA Ctrl+R  dbca  See my video and create Database Or All programs  Oracle-Oradb11g_home1  Configurations & migrations tools  Database configurations Assistance  Click fb:https://www.facebook.com/oraclesapdb fb group:https://www.facebook.com/groups/oraclesapbd/ blog site: http://oraclesapbd.blogspot.com/ twitter: https://twitter.com/oraclesapbd
Views: 160 Together Oracle
de/case sensitive passwords in oracle database 11g | Ten minute Code
Below Code CONN / AS SYSDBA CREATE USER apple IDENTIFIED BY apple; GRANT dba TO apple; conn apple/[email protected] conn apple/[email protected] SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON / ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = TRUE / ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE SELECT username, password_versions FROM dba_users;
Views: 78 Together Oracle
dba interview questions & answer in oracle | Ten Minute Code
Top Oracle DBA Interview Questions & Answer 1. Oracle DBA Characteristics Criteria Result Main storage structures Logical and Physical Architecture Grid architecture ACID Compliance Fully compliant Data stored as Data blocks, extents, segments and table spaces 2. What is Oracle? Oracle is a company. Oracle is also a database server, which manages data in a very structured way. It allows users to store and retrieve related data in a multi user environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery. A standby database is a database replica created by taking a backup of a primary database. 3. What is a Oracle Database? Oracle provides software to create and manage the Oracle database. The database consists of physical and logical structures in which system, user, and control information is stored. The software that manages the database is called the Oracle database server. Collectively, the software that runs oracle and the physical database are called the Oracle database system. A database buffer cache stores the data in memory for quicker access. The redo logs track and store all the changes made to the database. A Data Guard ensures data protection and high availability of data and control file records the physical structure of the database. Click on the above link to read more and to become a Oracle DBA. 4. What are the roles of DBA? DBA has the authority to create new users, remove existing users or modify any of the environment variables or privileges assigned to other users. • Manage database storage • Administer users and security • Manage schema objects • Monitor and manage database performance • Perform backup and recovery • Schedule and automate jobs 5. What are different Oracle database objects? • TABLES • VIEWS • INDEXES • SYNONYMS • SEQUENCES • TABLESPACES 6. What are the benefits of ORDBMS? The objects as such can be stored in the database. The language of the DBMS can be integrated with an object- oriented programming language. The language may even be exactly the same as that used in the application, which does not force the programmer to have two representations of his objects. 7. What is an Oracle index? An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table. 8. What are the Common Oracle DBA Tasks? As an Oracle DBA, you can expect to be involved in the following tasks: • Installing Oracle software • Creating Oracle databases • Performing upgrades of the database and software to new release levels • Starting up and shutting down the database • Managing the database’s storage structures • Managing users and security • Managing schema objects, such as tables, indexes, and views • Making database backups and performing recovery when necessary • Proactively monitoring the database’s health and taking preventive or corrective action as required • Monitoring and tuning performance In a small to midsize database environment, you might be the sole person performing these tasks. In large enterprise environments, the job is often divided among several DBAs, each with their own area of specialty, such as the database security administrator or database tuning expert. 9. List out the Tools for Administering the Database? The following are some of the products, tools, and utilities you can use in achieving your goals as a database administrator. -Oracle Universal Installer (OUI) The Oracle Universal Installer installs your Oracle software and options. It can automatically launch the Database Configuration Assistant to install a database. -Database Configuration Assistant (DBCA) The Database Configuration Assistant creates a database from templates that are Oracle supplied, or you can create your own. It enables you to copy a preconfigured seed database, thus saving the time and effort of customizing and generating a database from scratch. -Database Upgrade Assistant This tool guides you through the upgrade of your existing database to a new Oracle release. -Oracle Net Manager This tool guides you through your Oracle Net network configuration. -Oracle Enterprise Manager The primary tool for managing your database is Oracle Enterprise Manager, a web-based interface. After you have installed the Oracle software, created or upgraded a database, and configured the network, you can use Oracle Enterprise Manager as the single interface for managing your database. In addition, Oracle Enterprise Manager also provides an interface for performance advisors and an interface for Oracle utilities such as SQL*Loader and Recovery Manager.
Views: 418 Together Oracle
create vce  to pdf for vendor exam | Ten minute Code
below guide PDF file from VCE & XPS file from VCE How to create PDF file from VCE 1. Open VCE Designer Demo 2. Open VCE file where you place 3. Print to PDF 4. Save it How to create XPS file from VCE 1. Open VCE Designer Demo 2. Open VCE file where you place 3. Print to XPS 4. Save it create pdf to vce https://www.youtube.com/watch?v=ABpIVggBotY&feature=youtu.be
Views: 208 Together Oracle
Set Date Dropper plugins in Oracle Apex || 10 Minute Code
plugins link: https://github.com/OraCoolAPEX/apex-plugin-datedropper
Views: 41 Together Oracle
create batch file open facebook/google | Ten minute Code
Below Code @echo off echo Let me Open google for you PAUSE START http://www.google.com/? @echo off echo Let me Open facebook for you PAUSE START www.facebook.com
Views: 699 Together Oracle
connect oracle cmd command in oracle | Ten Minute Code
how to connect oracle cmd command in oracle set oracle_sid=orcl sqlplus Enter user-name: oe/[email protected] desc employees
Views: 51 Together Oracle
username password NOT Case sensitive in oracle | Ten Minute Code
Views: 461 Together Oracle
short cut run forms and  reports | Ten minute Code
Short Cut Windows+R Reports rwbuilder Forms frmbld
Views: 576 Together Oracle
create fiverr account | 10 Minute Code
To create an account: 1. From the Fiverr homepage, click Join. 2. Enter your email address and click Continue. ... 3. Choose a username. ... 4. Choose a password and click Join. 5. You are now a registered user on Fiverr. ... 6. Within the email you receive from Fiverr, click Activate Your Account.
Views: 43 Together Oracle