How To Guides

Follow these steps to convert FMB to FMT file in Oracle Forms. Steps Convert FMB to FMT in Oracle Forms In Oracle Forms, click on the menu File > Convert . A dialog window will open as shown below. Choose direction Binary-to-Text . Specify the FMB file in File field . Then click on the Convert button to convert into FMT file. You can now find the file excel_rep.fmt in the same folder location of the excel_rep.fmb file.

Use INTO clause to assign a value to a variable from the SELECT statement in PL/SQL. Below is an example: Assign Value to a Variable from SELECT Statement in PL/SQL Example In the following PL/SQL program, it will get the employee name into variable V_ENAME from the EMP table for employee number 7369. SET SERVEROUTPUT ON; DECLARE v_ename emp.ename%TYPE; BEGIN SELECT ename INTO v_ename FROM emp WHERE empno = 7369; DBMS_OUTPUT.put_line (v_ename); END; / Output SMITH PL/SQL procedure successfully completed. Assign Multiple Values to Multiple Variables In this example, it will get employee name and salary into V_ENAME and N_SAL variables from the EMP table. SET SERVEROUTPUT ON; DECLARE v_ename emp.ename%TYPE; n_sal emp.sal%TYPE; BEGIN SELECT ename, sal INTO v_ename, n_sal FROM emp WHERE empno = 7369; DBMS_OUTPUT.put_line ('Name: ' || v_ename); DBMS_OUTPUT.put_line ('Salary: ' || n_sal); END; / Ou...

You can write queries using SQL Editor in Toad for Oracle. Follow these steps: Write Query in Toad for Oracle Open Toad and connect to the Oracle database. Then click on the menu Database > Editor . An SQL Editor window will open. Here you can write the SQL queries as you write in SQL*Plus. After completing the query press Ctrl+Enter or F9 to execute. You can also format the SQL query in the Editor by pressing the Shift+Ctrl+F key combination or by clicking on the menu Edit > Format Code . Below is an example of a formatted SQL query: SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID FROM hr.employees WHERE department_id = 90 AND manager_id = 100 ORDER BY employee_id;

In HTML, if you are using PRE tag for preformatted text and the text is getting hidden, then use white-space and overflow-x CSS values for PRE tag. Below is the example: CSS To Wrap Text in PRE Tag pre { position: relative; max-width: 800px; padding: 30px 15px; background: #f7f7f7; word-break: break-all; word-wrap: break-word; white-space: pre-wrap; font-size: 14px; color: #666666; border-left: 3px solid #7b7b7b; overflow-x:scroll; } The output of the above CSS would be the same as it is displaying above for CSS code. Below is the image:

In this tutorial, you will learn how to add Google Analytics to Blogger with some easy steps. Steps To Add Google Analytics to Blogger Click the following link  https://analytics.google.com/analytics/web/  to Sign-UP with Google Analytics using your same Google account with which you created Blogger account. Google Analytics will quickly verify your website because it is already on Google's Blogger. After confirming your blog, Google Analytics will show you the Google tracking code as shown below. Just copy your UA ID from the highlighted part below.  <!-- Global site tag (gtag.js) - Google Analytics --> <script async src="https://www.googletagmanager.com/gtag/js?id= UA-XXXXXXXXX-X "></script> <script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', ' UA-XXXXXXXXX-X '); </script> Or copy from the highlighted parts shown in the...

In Hong Kong, if you are using Kabayan prepaid SIM card, here is how you can subscribe or unsubscribe CMHK Kabayan 4G and 3G Lite data packs for the internet. CMHK Kabayan 4G/3G Data Subscribe/Unsubscribe Options No. of Days Data Pack 4G/3G To Subscribe To Unsubscribe 5 Days 4G *103*300*04# ##103*300*04# 10 Days 4G *103*300*07# ##103*300*07# 30 Days 4G *103*300*06# ##103*300*06# 30 Days 3G *103*300*01# ##103*300*01# Monthly 4G and 3G Internet Data Pack Charges Price for 30 days 3G Lite data is $68 (HKD), and for 30 days 4G Lite data is $98 (HKD) if promotions then $88 (HKD). How to Check Balance of CMHK Kabayan Prepaid SIM? Dial *#130# to check the balance. For more details, you can review the following link: CMHK Kabayan Prepaid Sim Data Packs