[right-side]
In this tutorial, I will show you, how to install Oracle VM VirtualBox on Mac. For this demonstration, the version used for Oracle VM VirtualBox is 6.0.14 and for Mac is macOS Catalina. To start the installation, first you need to download the Oracle VM Virtual Box from one of the links below:
Now follow these steps to install the Oracle VM Virtual Box on macOS Catalina.

Steps to Install Oracle VM VirtualBox on Mac

1. After downloading the VirtualBox from the above-mentioned sources, you will get the DMG file with name something like as shown below:

VirtualBox-6.0.14-133895-OSX.dmg

Double click on this file, then it will extract the installation executable and then the following screen will appear.

1st Step of Oracle VM VirtualBox installation.

2. As shown above, double click on the icon VirtualBox.pkg, and it will prompt you to begin the installation with the screen shown below:

2nd Step of Oracle VM VirtualBox installation.

3. Click on the Continue button, then again click on the Continue button on the parent window.

4. Now on the next step click on the Install button.

5. The system will ask you the enter the password for the current user. Enter the password and click on the Install Software button.

6. Then it will install the Oracle VM VirtualBox on your Mac and maybe you will end up with the following screen:

3rd Step of Oracle VM installation on Mac.

Don't worry it is just a warning, your installation has been completed. Now go to the Application Launchpad to start the Oracle VM VirtualBox on Mac.

Oracle VM VirtualBox runtime on Mac OS Catalina.

You may also like:

In this tutorial, I will show you how to add Google Adsense code to the WordPress site using the right method. Yes, the right method means, just add single Google Adsense JavaScript and place the ads on the places you want. Also, the right method means to add Google Adsense JavaScript to the Footer, not in the Header. This way it will eliminate the JavaScript render-blocking warning. I am sure, that if you will use this method to add Adsense code to the WordPress site, it will not impact your website performance. Because if you put the Adsense code in the Head tag (<head></head>), it will definitely impact your WordPress site performance, which you can test using the website speed test tools such as Google PageSpeed and GTmetrix, etc.

Now I already brief you about it, that what are the advantages of adding Google Adsense Main JavaScript code to the Footer in WordPress site. So let's start the tutorial.

Steps to Add Google Adsense Code to WordPress Using the Right Method

1. Get Google Adsense Main JavaScript Code 

First, get the Google Adsense Main JavaScript code from the Adsense. To do this, open your Google Adsense Account page and click on the Ads and then from the right side pane click on the Get Code link to get the Single Google Adsense JavaScript code, as shown in the below image:

Get Google Adsense Main JavaScript code.

2. Install Plugin in WordPress to Insert Adsense Code to the Footer

You have copied the Adsense JavaScript code, now you have to install a plugin, through which you can add the code in the footer. To do this, open the WordPress click on the Plugins > Add New and search for the Header and Footer Scripts. You will find the Header and Footer scripts plugin as shown in the below image. Now click on the install button and then Activate it.

Install header and footer scripts plugin in WordPress.

3. Open the Header and Footer Script Page

After activating the plugin, click on the Settings > Header and Footer Scripts as shown in the below image:

Go to header and footer scripts setting page.

4. Add Google Adsense Code to WordPress

Now paste the Google Adsense JavaScript code in the Footer scripts area as shown in the below image:


Note: your Adsense JavaScript code may be different as shown in the above image because of Google code updates.

5. Enable Adsense Auto Ads

To enable Auto Ads, you need to click on the Pencil icon right side of your website name to enable Auto Ads. This is the page from where you copied the Adsense JavaScript code. Below is the image:


After enabling the Adsense auto ads, it is itself sufficient to show Ads on your site automatically in the appropriate places and this is the also right method. But mostly, we want the Google Adsense to show the ads on the places selected by us. To do this, follow these steps:

6. Create an Ad and get the JavaScript code

To create an Adsense Ad, click on the Overview page > By Ad Unit and then select the Ad type as shown in the below image:

Create Adsense Ad unit.

7. Save and Get the Ad Unit Code

After completing the Ad creation, save and get the code. As shown in the below image:

Save and Get Adsense Ad unit code.

[right-side] After copying the Adsense code, you no need to paste the full code because you have already added the main JavaScript (<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>). And if you will add full code then it will unnecessarily increase the JS code in your WordPress site, which will have a bad impact on your site. To take a specific part of this code, paste this code into a text editor and copy the only part as shown in the below example:

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle"
     style="display:block; text-align:center;"
     data-ad-layout="in-article"
     data-ad-format="fluid"
     data-ad-client="ca-pub-xxxxxxxxxxxx"
     data-ad-slot="11xxxxxxxx"></ins>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({});
</script>

8. Place the Adsense Code in Website's Widget Area

To place the above Adsense code in the WordPress site, click on the Appearance > Customize > Widgets > select the widget area and then add an HTML type widget and paste the above code in it.

Then click on the Publish button to save the changes and to make it live on the site. Google takes 4 to 5 minutes depends on your website traffic to display the ad.

To place the ads above posts or between posts follow this step:

9. Add Adsense code in the Post in WordPress

To insert ads between the WordPress posts, you need to install a plugin Post Adverts. To do this, click on the Plugins > Add New and search for the Post Adverts. Then install and activate the plugin.


Now click on the Post Adverts > Add New Post and paste the Adsense Ad code as shown in the 7th step. Here you can specify the display position of the ad to above post or below the post and after a specific paragraph, as shown in the below image:



This way you can add the Adsense code anywhere in your WordPress website.

So in this tutorial, you have learned the right method to add Adsense code to the WordPress site.

Related tutorial:

Computer not working.

Learn how to resolve computer issue, when the power light is on, but there is no apparent system activity.

Check the Power-Supply Voltages. Use a Voltmeter to Verify that Each Output from the Power Supply is Correct. Below the Table-1 Lists the Proper Voltage for Each Wire Color.

If any Output is very Low or Absent (Especially the 5-V Output ), Replace the Power Supply. Use a Voltmeter and Verify that the Power Good (or PwrOK) Signal is the +5 V. If this Signal is Below 1.0 V, It Might Inhibit the CPU from Running by Forcing a Continuous Reset Condition. Because the Good Power Signal is Generated by the Power Supply, Try Replacing the Power Supply.

Check to See that the CPU is Cool, that the Heatsink/Fan Assembly is Fitted on Correctly, and that the CPU Itself is Inserted Properly and Completely into its Socket.

Check the CPU Socket-If the CPU is Seated in a Zero Insertion Force (ZIF) Socket, Be Sure that the Socket's Tension Lever is Closed and Locked into Place.

If there is a Separate Math Coprocessor on the Motherboard (i286 and i386 Systems), Be Sure that the MCP is Inserted Properly and Completely into its Socket.

Next, Check the Expansion Boards and Be Sure that all Expansion Boards are Seated Properly. Any Boards that are not Secured Properly, or that are Inserted Unevenly Can Short Bus Signals and Prevent the PC from Starting.

Check the Motherboard for Shorts. Inspect the Motherboard at Every Metal Standoff and See that no Metal Traces are being Shorted Against a Standoff or Screw.

You Might want to Free the Motherboard and See if the System Starts. If it does, use Non-Conductive Spacers (Such as a Small Piece of Manila folder) to Insulate the Motherboard from Each Metal Standoff.

If the System Still Fails to Start (And all Voltages from the Power Supply are Correct), Replace the Motherboard.

Hope that helps.

Table-1: PINOUTS of ATX and Baby AT Power Connector

ATX Power Connector


COLOR VOLTAGE PIN
Orange +3.3 Vdc 1
Orange +3.3 Vdc 2
Black GND 3
Red +5 Vdc 4
Black GND 5
Red +5 Vdc 6
Black GND 7
Gray PwrOK 8
Purple +5V standby 9
Yellow +12 Vdc 10
Orange(22AWG) +3.3 Vdc 11
Brown (22AWG) 3.3 V sense 11
Blue -12 Vdc 12
Black GND 13
Green PS-ON 14
Black GND 15
Black GND 16
Black GND 17
White -5 Vdc 18
Red +5 Vdc 19
Red +5 Vdc 20

Baby AT Power Connectors


COLOR VOLTAGE PIN
Orange PwrOK 1 (P8)
Red +5 Vdc 2 (P8)
Yellow +12 dc 3 (P8)
Blue -12 Vdc 4 (P8)
Black GND 5 (P8)
Black GND 6 (P8)
Black GND 1 (P9)
Black GND 2 (P9)
White -5 Vdc 3 (P9)
Red +5 Vdc 4 (P9)
Red +5 Vdc 5 (P9)
Red 6 (P9)

Computer not running.

Learn how to resolve a computer issue, when there is no power light, but cooling fan is running.

Usually means that some level of ac power is reaching the system. Use a voltmeter and Confirm that there is Adequate ac Voltage at the wall outlet. Unusually low ac Voltages (Such as During "Brownout" Conditions) can cause the Power supply to Malfunction.

Verify that the Power-Supply Cables are Attached properly and securely to the Motherboard. Use a Voltmeter to Verify that Each output from the Power supply is Correct.

Table-1 illustrates the Proper Voltage for Each Wire/Color. If any Output is very Low or Absent (Especially the +5 Volt Output), Replace the Power Supply. Finally, Use a Voltmeter and Verify that the Power Good (or PwrOK) Signal is +5 V.

If this Signal is Below 1.0 V, it Might Inhibit the CPU from Running by Forcing a Reset Condition. Because the Power Good Signal is Generated by the Power Supply, Try Replacing the Power Supply.

Table-1: PINOUTS of ATX and Baby AT Power Connector

ATX Power Connector


COLOR VOLTAGE PIN
Orange +3.3 Vdc 1
Orange +3.3 Vdc 2
Black GND 3
Red +5 Vdc 4
Black GND 5
Red +5 Vdc 6
Black GND 7
Gray PwrOK 8
Purple +5V standby 9
Yellow +12 Vdc 10
Orange(22AWG) +3.3 Vdc 11
Brown (22AWG) 3.3 V sense 11
Blue -12 Vdc 12
Black GND 13
Green PS-ON 14
Black GND 15
Black GND 16
Black GND 17
White -5 Vdc 18
Red +5 Vdc 19
Red +5 Vdc 20

Baby AT Power Connectors


COLOR VOLTAGE PIN
Orange PwrOK 1 (P8)
Red +5 Vdc 2 (P8)
Yellow +12 dc 3 (P8)
Blue -12 Vdc 4 (P8)
Black GND 5 (P8)
Black GND 6 (P8)
Black GND 1 (P9)
Black GND 2 (P9)
White -5 Vdc 3 (P9)
Red +5 Vdc 4 (P9)
Red +5 Vdc 5 (P9)
Red 6 (P9)

Computer not starting.

Learn how to resolve the issue when there is no power light, and you cannot hear any cooling fan noise in the computer.

Chances are that there is Insufficient Power to the Computer. Use a Voltmeter and Confirm that there is Adequate ac Voltage at the Wall Outlet. Check the ac Cord next-it Might be Loose or Disconnected. See that the Power Switch is Turned on and Connected Properly. Check the Power-Supply Fuse(S). The Main Fuse Might have Opened. Replace any Failed Fuse.

If You Replace the Main Fuse and the Fuse Continues to Fail, You Might have a Serious Fault in the Power supply. Try Replacing the Power Supply.

Java Program

This tutorial is to show you how to declare variables in Java.

In Java, all variables must be declared before they can be used in the programs. The following is the syntax of variable declaration in Java.

Java - Variable Declaration Syntax

type identifier [ = value ][, identifier [ = value ] ...];

Here the type is the Java supported data types, or the class name, or interface name. The identifier is the name of the variable. To initialize a variable in Java, use equal sign and a value. To declare more than one variable of the same type, use a comma to separate.

Example - Declaring Variables in Java

In the following Java program, it is declaring multiple variables, and some of them include an initialization.

public class Variables {
    public static void main(String args[])
    {
        int x, y, z; // declares three intejers of x, y, and z.
        int a = 4, b, c = 9; // declares intejer a with value 4 and c with value 9 but b not yet initialized

        byte d = 21;
        double pi = 89.14252;
        
        char ch = 'x';
        
        String s = "abc";

        // printing the variables value that have been initialized
        System.out.println("a = " + a);
        System.out.println("c = " + c);
        
        System.out.println("d = " + d);
        System.out.println("pi = " + pi);
        
        System.out.println("ch = " + ch);
        System.out.println("s = " + s);        
        
        // variables x, y, z, and b not yet initialized
        
    }
}

Output

a = 4
c = 9
d = 21
pi = 89.14252
ch = x
s = abc

जानिये पेट और कमर की चर्बी कम करने के उपाय

शरीर पर मोटापे के बढ़ने के मुख्य संकेत

शरीर पर मोटापे के बढ़ने के मुख्य संकेत ठोड़ी नीचे व गले के ऊपर मांस बढ़ना और पेट कमर व कूल्हों की चर्बी बढ़ना होता है। मोटापा कम करने के लिए पेट व कमर को सही अनुपातिक आकार में करना पेहला कदम है। आज यहाँ आपके लिए, पेट और कमर की चर्बी कम कैसे करें इस विषय में कुछ कारगर उपाय प्रस्तुत करते है।

गलत ठंग से आहार विहार याने खान पान व रहन सहन से जब शरीर पर चर्बी बढ़ती है तो पेट बाहर निकल आता है, कमर मोती हो जाती है और कूल्हे भरी हो जाते हैं। इसी अनुपात से हाथ पैर और गर्दन पर भी मोटापा आने लगता है। जबड़ो के नीचे गर्दन मोटी होना और तोंद बढ़ना मोटापे के मोटे लक्षण है।

पेट और कमर की चर्बी कम करने के उपाय

मोटापे से जहां शरीर भद्दा दिखाई देता है वहीं स्वास्थय से सम्बंधित कुछ व्याधियां पैदा हो जाती हैं लिहाज़ा मोटापा किसी भी सूरत में अच्छा नहीं होता। बहुत कम स्त्रियां मोटापे के शिकार होने से बच पति हैं। हर समय कुछ न कुछ खाने की शौकीन, मिठाइयां, तेल पदार्थ का अधिक सेवन करने वाली और शारीरिक परिश्रम न करने वाली स्त्रियों के शरीर पर मोटापा आ जाता है।

प्रायः प्रसूति के बाद असावधानी, गलत आहार विहार से स्त्रियों का पेट बढ़ जाया करता है। गर्भ काल में जो स्त्रियाँ नाखून से पेट खुजाया करते हैं उनके पेट पर सफेद धारियां पड़ जाती हैं। जिन्हें किक्किस कहते हैं। प्रसव के बाद ४० दिन तक पेट बांध कर रखने से पेट बड़ा नहीं हो पता। पेट बांधने की बेल्ट बाजार में मिलती है। पहली कोशिश तो ये करनी चाहिए की पेट बढ़ने ही न पाये क्योंकि एक बार पेट बढ़ जाने पर कम करना कठिन और समय-साध्य कार्य हो जाता है। इसके लिए दो तीन बातों का ध्यान रखना जरुरी है।

प्रायः महिलाएं भोजन करके खूब पानी पिया करती हैं। इस विषय में निरोग धाम के गत अंकों में विस्तार से यह बताया जा चूका है की भोजन के अंत में पानी पीना उचित नहीं बल्कि १-१ घंटे बाद ही पानी पीना चाहिए। इससे पेट और कमर पर मोटापा नहीं चढ़ता बल्कि मोटापा हो भी तो कम हो जाता है

आहार भूख से थोड़ा कम ही भोजन खाना चाहिए।  इससे पाचन भी ठीक होता है और पेट बड़ा नहीं होता। पेट में गेस नहीं बने इसका ख्याल रखना चाहिए। गेस के तनाव से तन कर पेट बड़ा होने लगता है। दोनों समय शौच के लिए अवश्य जाना चाहिए। भोजन में शाक सब्जी, कच्चा सलाद और कच्ची हरी शाक सब्जी की मात्रा अधिक और चपाती, चावल व आलू की मात्रा कम रखना चाहिए। सप्ताह में एक दिन उपवास या एक बार भोजन न करने के नियम का पालन करना चाहिए। उपवास के दिन सिर्फ फल और दूध का ही सेवन करना चाहिए

बफारे की भाप - पेट की चर्बी कम करने के लिए

पेट व कमर की चर्बी कम करने के लिए सुबह उठने के बाद या रात को सोने से पहले नाभि के ऊपर उदर भाग को बफारे की भाप से सेक करना चाहिए। इसकी विधि -- एक तपेली पानी में एक मुठ्ठी अजवायन और एक चम्मच नमक दाल कर उबलने रख दें। जब भाप उठने लगे तब इस पर जाली या आटा छानने की छन्नी रख दें। दो छोटे नेपकिन या कपड़े ठन्डे पानी में गीले कर निचोड़ ले और थे करके एक-एक कर जाली पर रख गरम करें और पेट पर रख कर सकें। प्रति दिन १० मिनट सेक करना पर्याप्त है। कुछ दिनों में पे की चर्बी कम होने लगेगी।

मोटापा घटाने के आसन

सुबह उठ कर शौच से निवृत होने के बाद निम्नलिखित आसनों का अभ्यास करें या प्रातः २-३ किलोमीटर तक घूमने जाया करें।

पौष्टिक आहार

भोजन के गेंहू के आटे की चपाती लेना बंद करके जों और चने के आटे की चपाती लेना शुरू कर दें। इसका अनुपात है १० किलो चना और दो किलो जों। इन्हें मिलाकर पिसवा ले और इसी आटे की चपाती खाएं। इससे सिर्फ पेट और कमर का ही नहीं सारे शरीर की चर्बी कम होती है। प्रातः एक गिलास पानी में २ चम्मच शहद घोल कर पिने से भी मोटापा कम होने लगता है। दूध और शुद्ध घी का सेवन बंद करें।

इस प्रकार उपाय करके पेट और कमर का मोटापा घटाया जा सकता है। 

सीखें की नाड़ी परिक्षण कैसे करें |

नाड़ी परीक्षा का अभ्यास शुरू करने से पहले यह बहुत जरुरी है कि वात, पित्त और कफ के कुपित होने पर प्रकट होने वाले लक्षणों के विषय में पूरी जानकारी प्राप्त कर ली जाय, साथ ही इनके कुपित होने के कारणों के विषय में भी पर्याप्त जानकारी होना जरुरी है ताकि नाड़ी की गति को ठीक से देख के ये जाना जा सके कि कौन सा दोष कुपित हुआ है और उसके कुपित होने से क्या क्या लक्षण पैदा हो सकते है| इस जानकारी के आभाव में नाड़ी देखने में सिर्फ येही जाना जा सकेगा कि नाड़ी की गति सामान्य है या बड़ी हुई है| अन्य कोई बात नहीं जानी जा सकेगी|

नाड़ी देखने कि विधि

महापंडित रावण रचित ग्रन्थ "नाड़ी परीक्षा" में रोग परीक्षा करने के लिए, ये आठ वस्तुओं की परीक्षा करना आवश्यक बताया है --

१. नाड़ी
२. मूत्र
३. मल
४. जीभ
५. शब्द
६. स्पर्श
७. नेत्र
८. आकृति

सीधे हाथ के अंगूठे के नीचे कलाई की एक उंगल जगह छोड़कर, वैध अपने सीधे हाथ की पहली दूसरी और तीसरी अंगुली रख अंगूठे को कलाई के नीचे लगा कर नाड़ी दबाये और बाए हाथ से रोगी के हाथ को कोहनी से थाम के रखें|

पहली अंगुली के नीचे वात, बीच की अंगुली के नीचे पित्त और तीसरी अंगुली के नीचे कफ की स्थिति ज्ञात होती है| सूक्षम रीती से मन को एकाग्र करके पूर्ण दत्त चित होकर नाड़ी की इन विभिन्न गतियों को समझना ही नाड़ी परिक्षण है|

नाड़ी का परिक्षण तीन बार करने का विधान किया गया है ताकि बड़ी बारीकी से नाड़ी की स्थिति समझी जा सके| एक बार नाड़ी देखकर छोड़ दे फिर देखे| अपने बाए हाथ से रोगी की कोहनी थाम कर दाहिने हाथ धैर्य और एकाग्रता से चतुर और अनुभवी वैध को यत्त्न पूर्वक नाड़ी परिक्षण करना चाहिए|

वैध रोगी की नाड़ी परिक्षण करते हुए, पहली अंगुली का हल्का दबाव देकर, स्पन्दन का अनुभव करके वाट की स्थिति समझे, दूसरी अंगुली से पित्त की और तीसरी अंगुली से कफ की स्थिति समझें|

इन स्थिति को समझने और इसकी बारीकियों को ठीक-ठीक ढंग से पहिचानने के लिए किसी सिद्धहस्त और पुराने अनुभवी नाड़ी विशेषज्ञ की कृपा और शिक्षा प्राप्त करना बहुत आवश्यक है| ऐसा सुयोग किसी को मिल सके तो उसे अवश्य ऐसे ज्ञानी वैध को गुरु बनाकर सेवा करनी चाहिए और यह नाड़ी परीक्षा का ज्ञान प्राप्त करना चाहिए| जिन्हें ऐसा सुयोग न मिल सके, वे नाड़ी परिक्षण करने के विषय में आयुर्वेद शास्त्र के ग्रंथों में नाड़ी प्रकरण जहां जहां मिलिए उसका भली भांति अध्यन करके बार बार अपने निजी अभ्यास से नाड़ी परीक्षा करके अपने स्वयं के अनुभव को बड़ा कर स्वयं नाड़ी विशेषयगता अर्जित कर सकते है| धैर्य पूर्वक निरंतर यत्त्न करना जरुरी है| जो ऐसा नहीं कर सके या करना न चाहे उन्हे नाड़ी देखने के चक्कर में नहीं पड़ना चाहिए और खामखां नाड़ी देखने का नाटक नहीं करना चाहिए| 

Toronto Canada

Everyone wants to work in the best company for his growth and work & personal life balance. And if the opportunity is in abroad a country like Canada, then it would be much better. Glassdoor has an excellent review option so that employees can review their company which is very helpful for others to find the right company for him. That is why here I am giving the list of 10 best companies in Canada according to Glassdoor, where you can try to find an opportunity for you to have a great career.

List of 10 Best Companies to Work in Canada According to Glassdoor

  1. Microsoft is a computer hardware and software company, having 10000+ employees, revenue $10+ billion (CAD) per year, having rating 4.1, 85% recommended to a friend, and 95% approve of CEO.
  2. PointClickCare is computer hardware and software company, having 4000+ employees, having Glassdoor rating 4.5, 89% recommended to a friend, and 97% approve of CEO.
  3. SAP is computer hardware and software company, having 10000+ employees, revenue $10 billion (CAD) per year, having rating 4.5, 93% recommended to a friend, and 98% approve of CEO.
  4. Keg Restaurants is a restaurant, having 4000+ employees, revenue $500 million (CAD) per year, having rating 4.1, 86% recommended to a friend, and 97% approve of CEO.
  5. Ubisoft is a video games company, having 10000+ employees, revenue $5 billion (CAD) per year, having rating 3.8, 80% recommended to a friend, and 94% approve of CEO.
  6. LinkedIn is a business and employment oriented company, having 10000+ employees, rating 4.3, 86% recommended of a friend, and 96% approve of CEO.
  7. Facebook is an internet social media company, having 10000+ employees, rating 3.9, 96% recommended to a friend, and 100% approve of CEO.
  8. Google is an internet company, having 10000+ employees, rating 4.4, 89% recommended of a friend, and 94% approve of CEO.
  9. Lululemon is Department, Clothing, & Shoe Stores company, having 5000+ employees, revenue 500 billion (INR) per year, having rating 4.1, 84% recommended of a friend, and 89% approve of CEO.
  10. Southwest Airlines is Airlines, having 10000+ employees, rating 4.3, 87% recommended of a friend, 90% approve of CEO.

To run shell commands from Oracle Forms, use /bin/ directory as a source in the Linux or Unix environment. The following is the example:

Run Shell Command from Oracle Forms Example

Suppose you want to run mv command to move a file from one directory to another. Then use the host command as following:
host('/bin/mv /user01/myfiles/abc.txt /user01/oradocs/abctxt', no_screen);

If the file is too large, then it can take time to move from one folder to another, and in this case, Oracle Forms will be engaged until the command finish. So to run a command in the background put ampersand (&) in the end of the command. Below is the example:
host('/bin/mv /user01/myfiles/abc.txt /user01/oradocs/abctxt &', no_screen);
Execute Shell commands from Oracle Forms example.

Below is the example to find multiple strings in a file using the egrep command in Linux or Unix environment.

egrep Command to Find Multiple Strings in a File

In the following example, the egrep command will look for strings Scott, Smith and Phillip in all text files.
egrep 'Scott|Smith|Phillip' *.txt

Output:

emp.txt:1200|Scott|Technology|5500
emp.txt:9500|Smith|Technology|6000
emp.txt:9548|Phillip|IT|8000

To specify a particular file, you can specify the name instead of *.txt. For example:
egrep 'Scott|Smith|Phillip' emp.txt

egrep command example to search multiple patterns in a file in shell.

In this how-to guide, you will learn how to change the password in Toad for Oracle. Examples are below to change the password for the current Oracle user and any other user.

Steps to Change Password of Current User in Toad for Oracle

  1. In Toad for Oracle, connect to the database then click on the menu Session > Change Password.
  2. A dialog window open as shown in the below image. Specify the new password in the New Password field and re-type in the Verify Password field and click on the Execute button.
Change Oracle user password using Toad

Now the password will be changed for the current user.

Steps to Change Password of Any Other User Using Toad for Oracle

  1. In Toad for Oracle, click on the menu Database > Schema Browser.
  2. The Schema Browser window will open. Then click on the User tab.
  3. In the User tab, select the user for which you want to change the password.
  4. Then do the right-click on that user and from the shortcut menu choose Alter.
  5. The Alter User window will open as shown below. Then specify the New Password and click on the OK button to apply.

See also:

In this how-to guide, you will learn how to kill a session in Toad for Oracle.

To kill the session in Toad follow these steps:

  1. In Toad for Oracle, connect to the database with the user having ALTER SYSTEM KILL SESSION privilege or DBA privilege.
  2. After connecting to the Oracle database, click on the menu Database > Monitor > Session Browser.
  3. The Session Browser window will open, then select the session and do the right click on it and choose Kill Sessions option from the shortcut menu as shown in the below image.
Kill session in the Toad for Oracle example

The selected session will be killed immediately.

See also:


To generate HTML reports in Toad for Oracle follow these steps:

Generate HTML Report in Toad

  1. In Toad for Oracle, open SQL Editor by clicking on the Menu Database > SQL Editor.
  2. Then type your query in the editor for which you want to generate HTML report and press Ctrl+Enter or F9 to execute.
  3. You will get the result into the grid in Toad.
  4. Then do the right click on the grid and select Export Dataset option.
  5. Choose HTML Table from the Export Format drop-down list.
  6. In output choose File and type the filename in the File field.
  7. Then click on the OK button to generate the report as shown below:
Generate HTML report in Toad options

Output

HTML report output generated though Toad for Oracle.



Follow these steps to convert FMB to FMT file in Oracle Forms.

Steps Convert FMB to FMT in Oracle Forms

  1. In Oracle Forms, click on the menu File > Convert.
  2. 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.
Oracle Forms convert FMB to FMT file example.

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;
/

Output

Name: SMITH
Salary: 7450.6
PL/SQL procedure successfully completed.

Note: The SELECT statement should return one row to perform such queries.

Select INTO example in PL/SQL

You can write queries using SQL Editor in Toad for Oracle. Follow these steps:

Write Query in Toad for Oracle

  1. Open Toad and connect to the Oracle database.
  2. Then click on the menu Database > Editor.
  3. An SQL Editor window will open.
  4. Here you can write the SQL queries as you write in SQL*Plus.
  5. 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;

Create SQL queries in Toad for Oracle

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:

Wrap text in PRE tag using CSS

In this tutorial, you will learn how to add Google Analytics to Blogger with some easy steps.

Steps To Add Google Analytics to Blogger

  1. 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 below image:

Google analytics tracking code preview.

  1. But if you missed checking Analytics code at that time you can find by clicking on the Settings Icon > Tracking Info > Tracking Code.
  2. You have copied the Google Analytics UA ID, now return to Blogger and click on the Settings > Other.
  3. Then under Google Analytics, you will find the field Analytics Web Property ID.
  4. Paste the UA ID value in it and then click on the Save settings button.
You have now added Google Analytics to your blog, and you can start tracking.

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:

Powered by Blogger.