tag:blogger.com,1999:blog-41293462871957220052026-02-01T16:04:35.646-08:00ThinkTibits!Anonymoushttp://www.blogger.com/profile/07717408059667602415noreply@blogger.comBlogger831125tag:blogger.com,1999:blog-4129346287195722005.post-86866508819554424592020-07-19T00:20:00.001-07:002020-07-19T00:22:09.948-07:00How to Write the Times Table of Any Number Ending in 9Raajeshhttp://www.blogger.com/profile/17370004264098160043noreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-16185645728685565622020-07-13T18:36:00.000-07:002020-07-13T18:36:03.134-07:00How to write the multiplication tables for any three digit number - Speed maths tipsRaajeshhttp://www.blogger.com/profile/17370004264098160043noreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-54592670719286817652020-07-07T23:59:00.000-07:002020-07-07T23:59:25.372-07:00How to write the Multiplication tables for any two digit number - Speed Math MethodsRaajeshhttp://www.blogger.com/profile/17370004264098160043noreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-34768695448363494892020-07-06T21:45:00.001-07:002020-07-06T21:45:44.132-07:00How to Square Any Number Below 100 | Speed Math MethodsSrinihttp://www.blogger.com/profile/18235100062830291052noreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-74239795212895919362020-07-01T21:17:00.002-07:002020-07-05T18:36:19.548-07:00How to Multiply Numbers Near to 100 - Speed MathsRaajeshhttp://www.blogger.com/profile/17370004264098160043noreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-68684044164488874412020-07-01T16:55:00.002-07:002020-07-01T16:55:44.172-07:00How to Multiply Numbers Near 70, 80 and 90 - Speed Math TechniquesRaajeshhttp://www.blogger.com/profile/17370004264098160043noreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-84276195499637277322020-06-30T17:30:00.002-07:002020-06-30T17:30:40.960-07:00How to write the times table of 9 in a simple way - Math ShortcutsRaajeshhttp://www.blogger.com/profile/17370004264098160043noreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-4947341498128326442020-06-30T16:55:00.000-07:002020-06-30T16:55:06.722-07:00How to multiply numbers between 6 and 20 - Maths ShortcutRaajeshhttp://www.blogger.com/profile/17370004264098160043noreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-27752891122515243932020-06-30T16:53:00.000-07:002020-06-30T16:53:18.556-07:00How to Square Numbers Ending in 5 - Maths ShortcutRaajeshhttp://www.blogger.com/profile/17370004264098160043noreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-25005757415948651292020-06-30T16:51:00.000-07:002020-06-30T16:51:10.744-07:00How to multiply numbers near 20 - Maths ShortcutRaajeshhttp://www.blogger.com/profile/17370004264098160043noreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-65286998367513502642020-06-29T23:25:00.002-07:002020-06-30T16:32:28.301-07:00How to Multiply Numbers Near 50 in Vedic MathematicsRaajeshhttp://www.blogger.com/profile/17370004264098160043noreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-10823655741014153542014-09-21T22:12:00.001-07:002014-09-21T22:12:28.257-07:00POI Hide UnHide Rows Columns Java Example
In this tutorial, we will discuss how to hide / unhide rows / columns in an Excel worksheet using Apache POI, with suitable Java Examples.We will cover the following topics in this example:
Hide Single Row of Data
Hide Multiple rows in a worksheet
Hide rows with setZeroHeight method
Unhide rows (single / multiple) from a worksheet
Hide single / multiple columns
Unhide colums in a worksheet
Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-4129346287195722005.post-48399453418704459072014-09-17T04:58:00.001-07:002014-09-17T04:58:14.375-07:00Apache POI Excel Gradient Fill Example
In this tutorial, we discuss how to set Gradient Fill on Excel Cells using Apache POI / Java with example programs. Filling cell background with gradient color pattern is not available in POI at the time of writing, so we have to extend POI with the support of OOXML. This tutorial is applicable for XLSX formats only and includes the following sections:
Gradient Fill – Basic Example
Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-4129346287195722005.post-75618717815635550222014-09-14T20:47:00.000-07:002014-09-14T20:48:18.035-07:00Conditional Formatting Color Scales Java POI Example
In this post, we explain how to apply color scales in Conditional Formatting, on your Excel workbooks, with Apache POI / Java Example. A screenshot of color scales in Excel is shown below:
Conditional Formatting - Color Scales - Java POI Example
When you apply color scales to your Excel Data, Excel formats your data with min value and max value considered, as shown below:
Color Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-55980853066225071232014-09-11T01:13:00.000-07:002014-09-14T20:56:15.291-07:00Conditional Formatting Icon Set POI Java Example
In this post, we deal with icon sets in conditional formatting, and how to add icon set using Apache POI and OOXML with suitable Java Examples.Icon sets allow you to present your data beautifully on the spreadsheet. These are available under conditional formatting section as shown below:
Conditional Formatting - Icon Set - Apache POI Example
Adding these using POI is a simple task and Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-25640544213879705092014-09-10T18:17:00.000-07:002014-09-10T18:17:09.949-07:00Apache POI Custom Filters Java Example
In this part of Excel Apache POI AutoFilter approaches, we will discuss how to implement custom filter with Java examples. Let us examine custom filters on text columns, and then discuss how to implement the same on number columns.A list of custom filters that can be implemented includes;
Equals
Does Not Equal
Begins With
Ends With
Contains
Does not contain
You can find them in the Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-4129346287195722005.post-12257163056138499162014-09-05T06:16:00.001-07:002014-09-05T06:16:48.816-07:00Excel Auto Filter Cell Color - POI Java Example
In this post, let us see how to Auto Filter Excel Cell by Color, using Apache POI with a Java Example. You may have a need to apply color to your cells and auto filter them, and save the work book with a filter on a specific color. At the time of writing, POI does not support this natively, so we will have to do some tweaks to get this done in POI. The input and color filtered output is shown Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-4129346287195722005.post-9541670554773970812014-09-04T23:06:00.002-07:002014-09-04T23:06:57.473-07:00Excel Auto Filter - criteria Apache POI Example
Let us discuss how to expand the auto filter capabilities in Apache POI in this post.I wrote a tutorial initially that explained how to set auto filters using POI. But, that was very basic in nature and (at the time of writing) advanced filtering (Auto Filter with criteria) operations are not available in POI. In this post, you will find some Java examples to write your own auto-filter Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-4129346287195722005.post-72424218269513236742014-09-03T20:59:00.000-07:002014-09-03T20:59:47.689-07:00Excel Insert Format Table - Apache POI Example
This tutorial explains how to enable "Format as Table" option in Apache POI on Excel Workbooks with a Java Example. In Excel 2007 and above, there is an option to format your data by inserting a table.This option, "Format as Table" converts your data into a neat looking table, with the ability to perform additional operations on them. A screenshot is shown below:
Excel Format As Table - Unknownnoreply@blogger.com7tag:blogger.com,1999:blog-4129346287195722005.post-78776351913457663392014-08-31T21:13:00.000-07:002014-08-31T21:13:41.167-07:00Read / Parse JSON File PeopleCode Example
Let us examine how to read / parse JSON Data in PeopleCode with an example in this post. We will be using JSON.simple JAR files for this tutorial. JSON.simple is an open source library, compatible with your PeopleSoft JRE. The input JSON data will be available in a file named input.json.
Check here to write JSON data from PeopleSoft to a file.
1. Read / Parse JSON PeopleCode Example
We Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-4129346287195722005.post-23096023304604987922014-08-30T05:25:00.002-07:002014-08-30T05:46:44.207-07:00Create / Write JSON File PeopleCode Example
Let us see how to write data from PeopleSoft application as a JSON File in this tutorial. This piece of code can fit into Application Engine program or even in your record peoplecode and is so simple.We will use an open source Java library JSON.simple for this purpose.You don't need to be a Java expert, as you will appreciate the easiness with which you can generate JSON data at the end of thisUnknownnoreply@blogger.com1tag:blogger.com,1999:blog-4129346287195722005.post-61249843978283607782014-08-29T05:39:00.000-07:002014-08-29T05:39:02.907-07:00Read / Write CSV File PeopleCode Example
If you want to read / write comma separated file (CSV) using PeopleCode (Either in Page or Application Engine program), then this example is for you.
PeopleSoft does offer File layouts to parse CSV files in native format, but I would like to introduce you to an open source library, OpenCSV which can simplify the work for you. What's more, it is open source and you can use it on the fly with Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-4129346287195722005.post-44328285973848578652014-08-27T19:44:00.000-07:002014-08-26T03:27:35.254-07:00Read / Write Metadata - Excel POI Example
We have seen so much on working with actual data in POI so far. In this post, I would like to touch a bit on the metadata. A document is never complete without adding suitable metadata and Apache POI offers a plethora of options to set metadata against a document. We will discuss how to read and write metadata into Excel workbooks using Apache POI in Java with simple working examples in this Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-4129346287195722005.post-35064716066702561082014-08-26T21:32:00.000-07:002014-08-26T03:22:58.608-07:00Oracle Concepts Course - Part 2
Courtesy: Dizwell
The Structure of the Oracle Instance
An Oracle instance is merely an allocation of memory in which to do work plus a bunch of background processes which automate a lot of that work for us. The memory areas are collectively known as the System Global Area (or SGA for short). The constituent 'pools' of memory, which in the aggregate make up an SGA, are called The Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4129346287195722005.post-38041007320921070652014-08-19T22:23:00.002-07:002014-08-19T22:23:35.821-07:00Oracle Change Execution Plan for SQL
From Oracle 11g, there exists a new feature - SQL Plan Management, using which you can alter the execution plan of a query. This post aims to offer a simpler explanation of this works. To begin, let us create a simple table in a schema and pump millions of rows into it. This will provide us a test case that we can work upon. Use the SQL statement below for the purpose:
Create a test Unknownnoreply@blogger.com0