Posts

Showing posts with the label Oracle

Featured post

How to decode Tag-Length-Value Quickly

Basically, in TLV, the format is Tag, Length, and Value. In the list of protocols, TLV is one of the types. Transmitting the data depends on the protocol you used. However, many financial transactions still follow the TLV format. According to IBM, TLV data is three parts. The tag tells what type of data it is. The length field has a length of the value. The Value field has actual value.

Structure of TLV.TLV comprises three field values.  TagLengthValueEMV formulated different tags. They have their own meanings. Usually, the Tag and Length together takes 1 to 4 bytes.
The Best example for TLV.In the below example, you can find the sample TAG, LENGTH, and VALUE fields.

[Tag][Value Length][Value] (ex. "9F4005F000F0A001")
where

Tag Name = 9F40

Value Length (in bytes) = 05 
Value (Hex representation of bytes. Example, "F0" – 1-byte) = F000F0A001

In the above message, tag 9F40 has some meaning designed by EMV company. Here you can find a list of EMV Tags.
How to read the TLVTag: 1…

4 Top built-in functions in SQL with Examples

Image
You can find there are four different types of functions in SQL. All these functions are built-in functions. You no need to create these functions, and these come with your SQL.


I am discussing today the SQL functions List.
SQL functionsDATE-TIME functionsNumeric functionsChar functionsNull-related functions
1. DATE-TIME functions These functions are useful to get DATE and Time. Also, you can covert the DATE and TIME to Char. These are TO_CHAR, CURRENT_DATE, and CURRENT_TIME.

2. Numeric Functions These functions you can use for numeric calculations. Those are TRUNC, SIGN, ROUND, ABS.
3. Char Functions To handle string related tasks you can use CHAR functions. The CHAR functions are like SUBSTR, CONCAT, LENGTH.
4. NULL related functions To handle null values you can use different functions. Those are COALESCE, NVL, NULLIF

This post covered all your answers for the SQL functions list, SQL built-in functions in Oracle, and SQL functions in any DBMS.


Also, Read SQL tips to improve Query per…

Hyperion: How to Learn as Alternative for Mainframe

Image
Oracle Hyperion is a reporting tool. Its applications are Capital management, Asset planning, Workforce planning and more.Books to Read on Hyperion The Oracle Hyperion Financial Reporting 11 covers all basics to learn financial reporting using Hyperion tool.
The popular contents areExplore Grids and the Point of ViewCreate Functions and FormulasMaster Conditional Formatting and Conditional SuppressionCreate Dynamic Books and BatchesImport Reporting Content into MS Office with Oracle Smart View

Oracle flash storage system top features to read today

Image
Oracle flash storage is faster than other storage systems. This post tells why flash storage you need and the special features of flash storage from oracle.

Customers today are facing a triad of issues requiring higher performance from their storage systems such as More server and application virtualization, Faster servers and scale-out applications and Latency-sensitive applications.

Flash storage is seen as the solution to these issues because it delivers the desired higher performance. 
But does all of your data need flash media? 

What if there were “a smart and self-optimizing” storage system that automatically moves data across different media depending not only on frequency of usage, but also on the application’s performance requirements, media cost, and business value? Introducing Oracle FS1 Flash Storage System.

How is Oracle FS1 Flash Storage System Different?

Oracle FS1 intelligently delivers flash performance when you need it and reduces costs by moving data automatically to …

Oracle Hyperion Reporting Basic Tutorial

Image
Interactive Reporting is an extremely robust and powerful business intelligence tool providing ad-hoc querying, data analysis, dashboards, and other reporting capabilities.
Oracle Hyperion Financial Management Business analysts access the software through the EPM Workspace, a central location for viewing and managing content across all of the Hyperion products. The product is extremely flexible and provides analysts with the ability to quickly analyze data and produce deliverables. The software provides a consistent platform for managing content, where documents can be customized, saved, and shared across an organization. What is BQY When working with Interactive Reporting, it is hard to escape the term BQY. BQY or BrioQuery, is the extension given to all Interactive Reporting document files.

Developers create BQY files using the Workspace, Interactive Reporting Web Client, or Interactive Reporting Studio—a developer tool used to create and manage BQY documents outside of the EPM Work…