Oracel forms tutorial in bengali How to creating simple log in form

https://youtu.be/ynLFjILA0wY

Subscribe my channel :Mahfujur Rahman


Best Wishes

Md.Mahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.
Round-26
Mobile:01673472384
email:sendtomahfuj@gmail.com
facebook:mahfujur1989@yahoo.com

Creating Employeees Information form

Oracle Forms 10g Tutorial....

Thanks for watching.....

Subscribe my channel :Mahfujur Rahman


Best Wishes

Md.Mahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.
Round-26
Mobile:01673472384
email:sendtomahfuj@gmail.com
facebook:mahfujur1989@yahoo.com

Oracle forms 10g How to create list item

Oracle Forms 10g Tutorial..

How to create list item in oracle forms 10g?

Thanks for watching.....

Subscribe my channel :Mahfujur Rahman


Best Wishes

Md.Mahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.
Round-26
Mobile:01673472384
email:sendtomahfuj@gmail.com
facebook:mahfujur1989@yahoo.com

How to create calender in oracle forms 10g

How to create calender in oracle forms 10g

Requirements:

 01:Java Jar File.
 02:A function calculate the date in java jar file from sysdate.
 03:A procedure to call the function.
 04.Java implementation class.

Step 1:Start OC4j and run forms builder to create calender.

Step 2:take a text item in your canvas and edit its
 name to create calendar.

Step 3:create a bean area and rename and write the
 implementation class in the implementation area.

Step 4:copy your java jar file to your forms folder
 (where you installed your forms.)

Step 5: create a function in the program unit and take a name.

Step 6: write the function.

Step 7: write a trigger in the bean to call the function.

Step 8: use WHEN-CUSTOM-ITEM-EVENT trigger.

Step 9: compile your form and then run.

Your calender will show after clicking the bean area.


Thanks for watching.....

Subscribe my channel :Mahfujur Rahman


Best Wishes

Md.Mahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.
Round-26
Mobile:01673472384
email:sendtomahfuj@gmail.com
facebook:mahfujur1989@yahoo.com

Oracle Forms Tutorial in Bangla How to Create Alert Message

We will learn from this tutorial--
How to create Alert message in Oracle Forms 10g?

Subscribe my channel
Md.Mahfujur rahman
database design and development.
IDB-BISEW IT-Scholarship Project Round-26

Oracle Forms Tutorial in bangla Creating LOVs

We will learn how to create LOVs in oracle forms.

Steps are given below.....

Step 1: create a table wher you want to input data which will come from a table.(creating LOVs)

Step 2:Sart OC4j and run Form Builder and then connect for creating LOVs.

Step 3: Create a data block and select your created table for creating LOVs.

Step 4: now create a lov from the object navigator for creating LOVs.

Step 5: build a sql query with your table column and another table from which you will retrieve data. by creating LOVs.

Step 6: then ok. For creating LOVs.

Step 7: Compile your form and run for creating LOVs

Step 8: after opening the browser just press CTRL+L . your lov will show..

Step 10: Now you can also show your lov by a button. for creating LOVs.

Step 11: select WHWN-BUTTON-PRESSED trigger for showing LOVs .

Step 12: use "SHOW_LOV' built-in object in your trigger.

Step 9: Select your value ..then save

Thanks For Watching......
Subscribe my channel and stay connected with my tutorials.

Md.Mahfujur Rahman
Database Design and Development.

PLSQL tutorial in Bangla calculation with variable

How to calculate in PL/SQL language.
We will learn how to calculate with variable in PL/SQL.

Step 1: log in to your sql plus, and Set serveroutput        
              on(calculation with variable).

Step 2: Declare some variable to keep your data / number
             by which you can calculate with variables,

Step 3: assign variables number such as (20,30,50 etc), (calculation with variable)

Step 4: then use DBMS_OUTPUT.PUT_LINE statement to show the result for calculation with variable

Thanks For Watching
MdMahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.01673472384

Oracle Forms Tutorial How to convert content canvases item to tab canvas...

Today we will learn How to convert content canvases item to tab canvas page's

Step 1: Start your OC4j and Run your form builder to convert content canvas.
Step 2: Create a module to convert content canvases item.
Step 3: Create a data block from your database (select employees table information.) to convert content canvases item
Step 4: Select all column to show in the default content canvas to convert content canvases item
Step 5: Now create another tab canvas from the toolbar in the layout editor to convert content canvases item
Step 6:  Rename the label of the tab canvases page's to convert content canvases item
Step 7: Now go to the object navigator and select desired column item by pressing CTRL button and go to its property palette.
Step 8: Convert their canvas from content to tab canvas to convert content canvases item.
Step 9: And change their page name to convert content canvases item.
Step 10: By this way you can convert content canvases item to tab canvas and can show these item to the tab pages.

Thanks for watching......

Subscribe my channel : Mahfujur Rahman

Thanks For Watching
MdMahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.01673472384

Oracle Forms tutorial in bangla How to Load image

Today we will learn how to load image in oracle forms

Step 1:  start your oc4j to run the forms builder and run your forms builder to load an image.

Step 2: take a canvas to to load an image in your form module,

step 3: create an image item in your canvas to load your images in a block.

Step 4: set the properties palette of image style to adjust of the image item from toolbar to load images,

step 5: rename your image item name as your sweet will.

Step 6: create a Push Button to to load images.

Step 7: take some photos from your hard drive and saves in a folder to get the images quickly.

Step 8: now copy the path link and write your trigger in the Push button by using WHEN-BUTTON-PRESSED trigger to load images.

Step 9: then compile your form to load images

Step 10: Then run your form by clicking run, (before run you must log into your database).

Step 11: After running your form just click the push button

Step 12: Your image will view in your running browser.

By this way you can load images in your form.

Thanks for watching...

Subscribe my Channel : Mahfujur Rahman

Subscribe my channel : Mahfujur Rahman

Thanks For Watching
MdMahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.01673472384

Oracle Forms tutorial in bangla How to create dynamic list

Today we will learn
How to create a dynamic list in Oracle forms 10g
okay lets log on to your form builder as usual....

Step- 1: create a new data block and takes employees table
         information to create a dynamic list.

Step- 2: Rename your block name as your sweet will for
        creating the dynamic list

Step- 3: Decorate your items in your default canvas to see
        your dynamic list properly.

Step- 4: Now select your desired item where you want to
        create dynamic list.

Step- 5: Go to the property palette of that item
                (The dynamic list    item).

step- 6: change the item type to list item.
              (where dynamic list will show).

step- 7: and be careful about the list item list,make it blank.
       (sometimes it creates default (one) list).

step- 8: Now create a new record group from the
               navigator to see the  record in dynamic list.
                which will come from a query.

step- 9: rename the record group name as your wish.

step-10: go to the record group's property palette.

step-11: write the query in the 'record group query'
                to show the dynamic list.
step-12: close the record group.

step-13: now go to the object navigator of the
                dynamic list module.

step-14: write a 'WHEN-NEW-FORM-INSTANCE' TRIGGER
                 below the module to show
           the dynamic list properly.
step-15: then close your trigger.

step-16: compile your form and than run your form.


see the dynamic list what you wanted see.


if you have learned something from this tutorial
(how to create a dynamic list)
please like my video and subscribe my channel...

Thanks for watching....

Subscribe : Mahfujur Rahman....

Subscribe my channel : Mahfujur Rahman

Thanks For Watching
MdMahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.01673472384

Oracle forms tutorial in bangla Database Security by creating trigger

How to take database security by creating trigger in your schema..


Subscribe my channel : Mahfujur Rahman

Thanks For Watching
MdMahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.01673472384

Oracle Forms Tutorial How to clearify even and odd number for beginners ...

How to clearify even and odd number by oracle forms.
Actually what we have done in sql developer to show even and odd number we will do the same thing in oracle forms for user interface.
I hope this tutorial will help you create a form for even and odd number clearification.

Thanks
Md. Mahfujur RahmanSubscribe my channel : Mahfujur Rahman

Thanks For Watching
MdMahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.01673472384

Oracle forms Tutorial Part 2 How to use arithmetic operator in forms bui...

How to use arithmetic operator in forms builder?
Step 1 : At first start oc4j and minimize it.
Step 2 : Run your forms builder.
Step 3 : Connect your database with your forms builder.
Step 4 : Press f2 for showing your canvas/or click to the canvas option.
Step 5 : Take 3 text iteam as for declaring your variable.
Step 6 : You can also copy a text item by pressing ctrl+d.
Step 7 : go to the property palette by pressing f2/ double click.
Step 8 : rename your variables name.
Step 9 : take a PUSH BUTTON for seeing your result.
Step 10: rename your push button as save.
Step 11: now write your trigger to the "WHEN BUTTON PRESSED" option.
by right click to the button.
Step 12: compile your form and then click to the RUN tool.


If your browser will be in default option and your java settings
have been correctly connected with forms then your form will run
in your browser.

Thanks again for watching

Please subscribe my channel :mahfuj


Oracle forms Tutorial Part 2 How to use arithmetic operator.
Subscribe my channel : Mahfujur Rahman

Thanks For Watching
MdMahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.
01673472384


https://www.facebook.com/seomahfuj

• 
  

  Category
  

  • Education

Creating Employeees Information form