Select few sample records from a Teradata table using Sample function
Sample function in Teradata The Sample function is used in the SELECT query to return the random number of rows.It
Continue readingConvert bytes to KB,MB and GB using Java Program
In many cases, we might get the memory or size of the file/table in bytes.The simple java program can able
Continue readingExecute the shell commands using ProcessBuilder in Java
We can execute the shell commands using the Java.lang.ProcessBuilder class in Java.Lets see the program to execute the shell commands.
Continue readingConvert String to Int in Java with examples
Integer.parseInt() We can convert the String value to int in Java using Integer.parseInt() method. If the String variable contains only
Continue readingImplementation of Linked List in C++ with examples
Linked list in C++ Linked list is one of the data structure that used to overcome the limitation of array.
Continue readingHive describe command to check the meta data of the Hive table
We can see the Hive tables structures using the Describe commands. This command shows meta data about the hive table
Continue readingHow to check the table size using query in Teradata
Table size in Teradata: DBC.ALLSPACE is the system table used to find the space occupied for each table or database
Continue readingSelect number of records from a table using TOP function in Teradata
Some time we wants to fetch sample rows from the table. If we use SELECT * in the query,it will
Continue readingCalculate BMI(Body Mass Index) using PHP program
BMI calculator: Body mass index (BMI) is a measure of body fat based on height and weight that applies to
Continue readingTeradata XMLAGG function with examples
XMLAGG function: The XMLAGG function is used to perform an aggregate of multiple rows. This can used for multiple purpose
Continue reading