English is the primary language while working on Computers, Software, etc. Keyboards are also mostly in English, except in some of the countries like Japan, China. These countries use their own language keyboards. Practically, it is not possible to create that many Keyboard hardware layouts for each regional language. What if you want to write …
This article explains how to use Excel to generate SQL statements like drop table, insert and update easily using built-in CONCATENATE excel function. Microsoft Excel is one of the most used product in the IT Industry for project management and tracking. It is a great product. You can use it to do simple tasks and …
How to use Excel Spreadsheet to generate SQL statements Read More »
Use below query to get the current executing statement in Oracle Apps concurrent programs. SELECT va.sql_text ,va.module FROM APPS.fnd_concurrent_requests fcr ,V$SESSION vs ,V$SQLAREA va WHERE fcr.oracle_session_id = vs.audsid AND vs.sql_hash_value = va.hash_value AND fcr.request_id = <request_id>; Table Information fnd_concurrent_requests:- This table holds the history of all submitted program in Oracle Apps like request id, request …
Query to get current executing statement in Oracle concurrent program Read More »
This article explains how to use the XAMPP control panel to start/stop, administer/ configure services like Apache, MYSQL, FileZilla, Mercury, Tomcat with just a click of a button. Before moving further, let’s discuss XAMPP in Brief. XAMPP XAMPP is free and easy to install Apache distribution. It acronyms to Cross-Platform (X), Apache (A), MariaDB (M), PHP …
XAMPP Control Panel – Manage/Configure Apache, MySQL, FileZilla, Tomcat, Mercury Read More »
Control M or Ctrl-M or ^M character whatever you call them creates the problem when present in Unix or Linux text files. The presence of these characters may lead to unexpected results or interrupt the working of shell script, configuration files, etc. Unix /Linux is the most widely used operating system for server and database …
What is ^m character and how to find and remove it from Unix/Linux text file? Read More »
PuTTY is an SSH and Telnet client for the Windows platform. DBAs, Network Admins, and Developers can’t imagine a day without it while working on a remote UNIX or Linux Server. It is most widely used in server administration tasks. This free and open-source software was originally developed by Simon Tatham and is now supported …
XAMPP is a completely free, open-source, and easy to install Apache distribution containing Apache HTTP Server, MariaDB, PHP, and Perl and other supporting modules like FileZilla, Tomcat, Mercury, etc. It is released by apache-friends which is a non-profit project to promote the Apache webserver under GNU General Public License. Here, X stands for Cross-Platform, A …
Delimited files are basically text files where a character like a comma(‘,’), tab, or pipe(‘|’) delimits (separates) words. You can also use your own character to create a delimited file. Most spreadsheet applications like Excel can directly open or provide a way to import the file. Here, we will show how to open delimited files …
How to Open CSV, PIPE and TAB Delimited File in Excel Read More »
Your email is one of the most important online assets that you have. Nowadays, you use email for everything, credit card statements, bank statements, etc. It contains a lot of personal and important information. Hackers are in search of information they could exploit to get some financial benefits. So, how to safeguard your email Account …
How to turn on and off Google 2-step verification in Gmail Read More »
