Vanilla is forum software. It provides a modern community platform for organizations. Companies like Adobe, EA, Acer, Nokia are using it. You can visit the showcase page for additional details. It helps improve customer service, increase advocacy, and strengthen brand loyalty. This forum is also available as a software-as-a-service (cloud) which is paid and good for […]
How to Install Vanilla Forum Software on Windows 10 Read More »
Working on Technical Specifications and looking for a way to interlink sections in Microsoft Word? You are writing a pseudo algorithm and want to link with SQL which are part the same document as shown in the below image. Microsoft word provides a bookmark and hyperlink feature which can help you to achieve this. Create
How to create Hyperlink and Bookmark in Microsoft Word Read More »
Awesome Screenshot is a free browser extension available for popular browsers like Chrome, Firefox, and Safari which helps you to capture images and add Annotations like blurring sensitive info, adding titles, creating custom shapes for your blog. You can create an arrow, write text, create a circle, etc and save a screenshot for personal records
Awesome Screenshot – (How to) Install and Capture Images, Record Videos Read More »
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
^M Character – Find and Remove it from Unix/Linux text file Read More »
PuTTY is a free and open-source SSH and Telnet client for the Windows. It is originally developed by Simon Tatham and now supported by a group of volunteers. This terminal emulator helps to access server over a network remotely using the secure shell (ssh) protocol. Some of the key features of Putty, Open source available
How to Install and Use Putty on Windows Read More »
XAMPP is a completely free, open-source, and easy-to-install Apache distribution containing Apache HTTP Server, MariaDB, PHP, 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 web server under GNU General Public License. Here, X stands for Cross-Platform, A stands for
How to Install XAMPP on Windows 10 Read More »
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 »