Posts

Showing posts from October, 2018

How to Convert FMB to FMT in Oracle Forms?

Image
Follow these steps to convert FMB to FMT file in Oracle Forms.
Steps Convert FMB to FMT in Oracle FormsIn 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.

How To Assign Value To Variable From Select Statement in PL/SQL?

Image
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; / OutputSMITH 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; / OutputName: SMITH …

How To Write Query in Toad for Oracle?

Image
You can write queries using SQL Editor in Toad for Oracle. Follow these steps:
Write Query in Toad for OracleOpen 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;

How to Wrap Text in PRE Tag?

Image
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 Tagpre { 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:


How To Add Google Analytics To Blogger?

Image
In this tutorial, you will learn how to add Google Analytics to Blogger with some easy steps.
Steps To Add Google Analytics to BloggerClick 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 below image:


Bu…

How to Subscribe/Unsubscribe CMHK Kabayan 4G/3G Data?

Image
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 OptionsNo. 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