How to get digital clock at runtime in oracle forms

How to know your oracle SID name

DBA Tutorial in Bangla 5 :What is Oracle Enterprize Manager?

DBA Tutorial 4: How to create a new database in Oracle Database SQL/PLUS

আপনি কি নতুন করে আরও একটি ডাটাবেজ তৈরি করতে চান। নতুন করে ডাটাবেজ create করে সেইখানে আপনি Schema Create করে কাজ করতে চান। তাহলে দেখে নিন কিভাবে আপনি একটি Brand New ডাটাবেজ create
করবেন।

DBA Tutorial 1:Database Startup Mood

How to open another file by creating batch file?

How to Hide Hard Drive without using any software

How to install Oracle database SQL/PLUS 11g

Today we will learn...
How to install Oracle Database 11g
Just watch the video...and then try yourself....

https://youtu.be/kHMOBYaycsU

Just watch the video carefully i hope you will understand better.
                               
                               ''Happy Tutorial Watching''
...................................................Finish..................................................

To get my others videos just go to the link which is given below..

https://www.youtube.com/channel/UCFcOAx6xy6aQgKzJFaJ_8zQ
https://youtu.be/jko_6VaP5s8
https://youtu.be/ufo1eOlLGE0
https://youtu.be/rWU2DBCaTf8
https://youtu.be/OL6Stb9II30
https://youtu.be/_dr-KZIs_fQ
https://youtu.be/BTYDJR0zIiQ
https://youtu.be/1n1Wej_uWsA
https://youtu.be/ynLFjILA0wY
https://youtu.be/GeSic9Dwt5A
https://youtu.be/z31hMeb5H5w
https://youtu.be/4qHR96zOTCM
https://youtu.be/LhPN_bTWAj8
https://youtu.be/KHqtbplh7c0
https://youtu.be/UbcHcggmZAc
https://youtu.be/99Gfy2eVaWU
https://youtu.be/xLCQ7FVKlbA
https://youtu.be/ncFD3vDMt-M
https://youtu.be/LrQ_9-jlEko
https://youtu.be/aHKfJa-qmks
https://youtu.be/Egm-92rvoaM
https://youtu.be/YUja468gbWA
Stay connected with information...
Stay Connected with my tutorial..
Stay connected with updated reports tutorial...
Keep learning about Oracle Databese .......


Thanks for watching...

Subscribe my Channel : Mahfujur Rahman

Subscribe my channel : Mahfujur Rahman

https://www.facebook.com/datasoftbd/?fref=ts

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

Oracle Reports Conditionally Formatting

How to formatting conditionally in Oracle reports 10g at run time?
Actually to get specific information or data from a huge report we will use this method.
When its need to know a specific Salary range  we will use this conditionally formatting.

Just watch the video carefully i hope you will understand better.
                               
                               ''Happy Tutorial Watching''
...................................................Finish..................................................

To get my others videos just go to the link which is given below..

https://www.youtube.com/channel/UCFcO...
https://youtu.be/jko_6VaP5s8
https://youtu.be/ufo1eOlLGE0
https://youtu.be/rWU2DBCaTf8
https://youtu.be/OL6Stb9II30
https://youtu.be/_dr-KZIs_fQ
https://youtu.be/BTYDJR0zIiQ
https://youtu.be/1n1Wej_uWsA
https://youtu.be/ynLFjILA0wY
https://youtu.be/GeSic9Dwt5A
https://youtu.be/z31hMeb5H5w
https://youtu.be/4qHR96zOTCM
https://youtu.be/LhPN_bTWAj8
https://youtu.be/KHqtbplh7c0
https://youtu.be/UbcHcggmZAc
https://youtu.be/99Gfy2eVaWU
https://youtu.be/xLCQ7FVKlbA
https://youtu.be/ncFD3vDMt-M
https://youtu.be/LrQ_9-jlEko
https://youtu.be/aHKfJa-qmks
https://youtu.be/Egm-92rvoaM
https://youtu.be/YUja468gbWA
Stay connected with information...
Stay Connected with my tutorial..
Stay connected with updated reports tutorial...
Keep learning about Oracle Databese .......


Thanks for watching...

Subscribe my Channel : Mahfujur Rahman

Subscribe my channel : Mahfujur Rahman

https://www.facebook.com/datasoftbd/?...

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

How to create master-detail report manually

You will learn from this tutorial that how to create master detail report manually in Oracle Reports Builder.


https://youtu.be/ufo1eOlLGE0

...................................................Finish..................................................

To get my others videos just go to the link which is given below..

https://www.youtube.com/channel/UCFcO...
https://youtu.be/ufo1eOlLGE0
https://youtu.be/rWU2DBCaTf8
https://youtu.be/OL6Stb9II30
https://youtu.be/_dr-KZIs_fQ
https://youtu.be/BTYDJR0zIiQ
https://youtu.be/1n1Wej_uWsA
https://youtu.be/ynLFjILA0wY
https://youtu.be/GeSic9Dwt5A
https://youtu.be/z31hMeb5H5w
https://youtu.be/4qHR96zOTCM
https://youtu.be/LhPN_bTWAj8
https://youtu.be/KHqtbplh7c0
https://youtu.be/UbcHcggmZAc
https://youtu.be/99Gfy2eVaWU
https://youtu.be/xLCQ7FVKlbA
https://youtu.be/ncFD3vDMt-M
https://youtu.be/LrQ_9-jlEko
https://youtu.be/aHKfJa-qmks
https://youtu.be/Egm-92rvoaM
https://youtu.be/YUja468gbWA
Stay connected with information...
Stay Connected with my tutorial..
Stay connected with updated reports tutorial...
Keep learning about Oracle Databese .......


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 Reports Formula

.

Today we will learn about Oracle reports formula. I mean How to use formula in a column in Oracle reports.
For this just try to follow the steps which are given below----

Step 1: create a simple Group Above report to use formula in oracle report.
Step 2: Go to the Paper Layout option to use formula in oracle report
Step 3: Copy a number data type field from the paper layout to use formula in oracle report
Step 4: and place your copied field in the right area as I have shown in the videos to use formula in oracle report
Step 5: After this go to the Data Model option to use formula in oracle report
Step 6: and click to the formula tool and sketch the right group area  to use formula in oracle report.
Step 7: after this it will create a formula column and will take a default unique name  to use formula in oracle report.
Step 8: double click on the name an it will transfer you to its property inspector  to use formula in oracle report.
Step 9: Just change the data type and write down the Function in the PL/SQL area  to use formula in oracle report.
Step 10: then close it to  to use formula in oracle report.
Step 11: go to the design option and select the field what you have copied and go to its property inspector.
Step 12: Just replace the data source option to the formula name  to use formula in oracle report.
Step 13: then close it and compile it and then click to the Run report option.
Step 14: Your desired value will return in that field by using formula.


..................................................Finish..................................................

To get my others videos just go to the link which is given below..

https://youtu.be/rWU2DBCaTf8
https://youtu.be/OL6Stb9II30
https://youtu.be/_dr-KZIs_fQ
https://youtu.be/BTYDJR0zIiQ
https://youtu.be/1n1Wej_uWsA
https://youtu.be/ynLFjILA0wY
https://youtu.be/GeSic9Dwt5A
https://youtu.be/z31hMeb5H5w
https://youtu.be/4qHR96zOTCM
https://youtu.be/LhPN_bTWAj8
https://youtu.be/KHqtbplh7c0
https://youtu.be/UbcHcggmZAc
https://youtu.be/99Gfy2eVaWU
https://youtu.be/xLCQ7FVKlbA
https://youtu.be/ncFD3vDMt-M
https://youtu.be/LrQ_9-jlEko
https://youtu.be/aHKfJa-qmks
https://youtu.be/Egm-92rvoaM
https://youtu.be/YUja468gbWA


Stay connected with information...
Stay Connected with my tutorial..
Stay connected with updated reports tutorial...
Keep learning about Oracle Databese .......


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

How to use parameter as well as Parameter list in oracle reports

After watching this tutorial you will able to learn About
How to user Parameter as well as Parameter List at run time in Oracle Reports Builder....

https://youtu.be/OL6Stb9II30

Step 1: Create a simple report by using Oracle reports Wizard.
Step 2: After creating the report go to its data model source
Step 3: Click to the data source from where the group information started.
Step 4: After double clicking there you will see the sql query
Step 5: write the WHERE condition and name the prameter name with colon
Step 6: Click to the OK button
Step 7: Then Run your report
Step 8: After running there will show a parameter form builder
Step 9: write down your desired info into the box then press ENTER.
Step 10: You will See the changes and will find only your desired information.
Step 11: After this now we will create a parameter list.
Step 12: Just go to the Parameter Layout from TOOL. Menu
Step 13: Select the parameter name and the go to its property inspector.
Step 14: Change the data type as your data source
Step 15: Write down the initial value.
Step 16: After that click to the parameter list.
Step 17: It will show you a window where you have to write in the select command
Step 18: Write down the sql command from which you data will be retrieved.
Step 19: Then click OK. and Run your report.
Step 20: Your parameter layout will generate a parameter list in its layout editor.
Step 21: Select your desired id or no. and then press ENTER.
Step 22: Your report will run as your estimated wish.
 ...................................................Finish..................................................

To get my others videos just go to the link which is given below..

https://www.youtube.com/channel/UCFcO...
https://youtu.be/OL6Stb9II30
https://youtu.be/_dr-KZIs_fQ
https://youtu.be/BTYDJR0zIiQ
https://youtu.be/1n1Wej_uWsA
https://youtu.be/ynLFjILA0wY
https://youtu.be/GeSic9Dwt5A
https://youtu.be/z31hMeb5H5w
https://youtu.be/4qHR96zOTCM
https://youtu.be/LhPN_bTWAj8
https://youtu.be/KHqtbplh7c0
https://youtu.be/UbcHcggmZAc
https://youtu.be/99Gfy2eVaWU
https://youtu.be/xLCQ7FVKlbA
https://youtu.be/ncFD3vDMt-M
https://youtu.be/LrQ_9-jlEko
https://youtu.be/aHKfJa-qmks
https://youtu.be/Egm-92rvoaM
https://youtu.be/YUja468gbWA

Stay connected with information...
Stay Connected with my tutorial..
Stay connected with updated reports tutorial...
Keep learning about Oracle Databese .......


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 Reports How to create a Simple Tabular Report

Today we will learn about Oracle Reports.
This tutorial will teach you to make a simple oracle report.

After watching this tutorial you will able to create a simple tabular report in your reports builder.

My others tutorials about Oracle Database and oracle Forms are here :
https://www.youtube.com/channel/UCFcO...

Suscribe my channel : Mahfujur Rahman
Share my videos in your social media and lets try to know others about Oracle Reports and make them clear that is the way to learn anything from internet.

If you have any kind of query just write down in the comments box or you can also mail,or call me for better communication. I will try heart and soul to figure out your problems about my tutorials.

Regard & Best Wishes

Md. Mahfujur Rahman
Database Design & Development
IDB-BISEW IT Scholarship Project
Cell    : 01673-472384
          : 01728-841880
E-mail: sendtomahfuj@gmail.com
Web  : cfsolution.blogspot.com
Facebook: facebook.com/seomahfuj

https://www.youtube.com/channel/UCFcO...https://youtu.be/BTYDJR0zIiQ

Oracle Reports: Introduction to Oracle Reports 10g

Today we will learn about Oracle Reports.
This tutorial will introduce you to oracle reports builder.
After watching this tutorial you will able to create a simple report in your reports builder.

My others tutorials about Oracle Database and oracle Forms are here :
https://www.youtube.com/channel/UCFcOAx6xy6aQgKzJFaJ_8zQ

Suscribe my channel : Mahfujur Rahman
Share my videos in your social media and lets try to know others about Oracle Reports and make them clear that is the way to learn anything from internet.

If you have any kind of query just write down in the comments box or you can also mail,or call me for better communication. I will try heart and soul to figure out your problems about my tutorials.

Regard & Best Wishes

Md. Mahfujur Rahman
Database Design & Development
IDB-BISEW IT Scholarship Project
Cell    : 01673-472384
          : 01728-841880
E-mail: sendtomahfuj@gmail.com
Web  : cfsolution.blogspot.com
Facebook: facebook.com/seomahfuj

https://www.youtube.com/channel/UCFcOAx6xy6aQgKzJFaJ_8zQhttps://youtu.be/BTYDJR0zIiQ

How to create menu smart bar in oracle forms builder

We will learn by this tutorial:
https://youtu.be/1n1Wej_uWsA

How to create menu smart bar in oracle forms builder?

I hope you will understand clearly by watching this video tutorial.

Steps:

Step 1 : click to the menus icon and then create. to create menu smart bar.
Step 2: go to the menu editor by F4  to create menu smart bar.
Step 3: take new toolbar as more as you want to create menu smart bar.
Step 4: write the pl/sql code in the menu button to create menu smart bar.
Step 5: save the menu in your hard drive to create menu smart bar.
Step 6: then compile your menu to create mmx file.
Step 7: then take any form where you want show the menus.
Step 8: go to that forms module's property palette and insert the path of your menu what you have saved to create menu smart bar.
Step 9: add also the mmx files of menu to create menu smart bar.
Step 10: compile and run the form to create menu smart bar.

If you got help from this video please share this video and subscribe my channel...

My Channel: Mahfujur Rahman
https://www.youtube.com/channel/UCFcO...

 Creating menu your form will show smooth and safe as well as secured.
Regard & Best Wishes

Md. Mahfujur Rahman
Database Design & Development
IDB-BISEW IT Scholarship Project
Cell    : 01673-472384
          : 01728-841880
E-mail: sendtomahfuj@gmail.com
Web  : cfsolution.blogspot.com
Facebook: facebook.com/seomahfuj


https://youtu.be/0b7cCTcHPgc

My others video links are----
https://youtu.be/ynLFjILA0wY
https://youtu.be/WYTQgM4TXB0
https://youtu.be/z31hMeb5H5w     https://youtu.be/1n1Wej_uWsA

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

How to make a simple form by oracle forms developer Part 1

Mahfuj2

bondhu tor laiga by dedar