Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
What is Hash Table in PowerShell?
Hash table in a PowerShell is constructed with the Key-Value combination. Each key has its own value, so to get the value we need to refer the Key. We don’t need numeric indexing like Array to refer values.This is how the hash table looks like.Name Value ---- ----- EmpName Charlie City New York EmpID 001In the hash table creation, keys and values are separated with Semi-colons (;). In the above example, EmpName, City and EmpID are referred as keys while Charlie, New York ...
Read MoreWhat are the benefits of a module in Java 9?
An important feature introduced in Java 9 is Module. By using a module, we can divide the code into smaller components called modules. It means each module has its own responsibility and declare its dependency on other modules to work correctly.Below are the steps to create a modular project in Java 9:Initially, we can create a file named "module-info.java" and add to a package(module) for which it is created. For instance, if our package name is com.mycompany.mypackage then the file goes to the same package (src/com.mycompany.mypackage/module-info.java). We can create a module by declaring "exports" and "requires" expressions.If our modules require another module ...
Read MoreMySQL Order by a specific column x and display remaining values in ascending order
Let us first create a table −mysql> create table DemoTable -> ( -> MonthNumber int -> ); Query OK, 0 rows affected (1.68 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(10); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values(1); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values(9); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values(6); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(8); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values(5); ...
Read MoreDelete a specific record from a MySQL table by using AND in WHERE clause
MySQL AND is used in WHERE to fetch a record by filtering using multiple conditions. Let us first create a table−mysql> create table DemoTable -> ( -> Id int, -> Name varchar(20) -> ); Query OK, 0 rows affected (0.70 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(101, 'Chris'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(102, 'David'); Query OK, 1 row affected (0.51 sec) mysql> insert into DemoTable values(103, 'Bob'); Query OK, 1 row affected (0.14 sec)Display all records from the table using select statement ...
Read MorePassing multiple parameters in SAP BO Webi report
An open document URL is constructed as follow −http://:/OpenDocument/opendoc/?&&...&With use of SAP Business Objects API, you can query each prompt- single value or multiple value. When you build URL, you may have to include parameter types.You can join parameters with the ampersand (&) and you shouldn’t use space with & ampersand. Example − sType=wid&sDocName=Sales2003https://URL_path/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&sType=wid&sRefresh=Y&iDocID=AUcrjvCCPOVHtSvXJV9Qs0k&lsMYBO_BU=B;B&lsSYBO_CALYEAR=201710&lsSYBO_CRNCY=USDIn this URL, you can see single value variable YBO_CALYEAR and value is passed in YYYYMM format&lsSYBO_CRNCY=USD, you can see single value variable and I am passing value “USD”When you run the report, you can define a report level variable or use report-level function to capture multiple ...
Read MoreSort records with special characters like '2321/78/54-6'
To sort, use ORDER BY SUBSTRING(). Let us first create a table −mysql> create table DemoTable -> ( -> Value varchar(40) -> ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2321/78/54-6') -> ; Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('2321/78/54-8'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('2321/78/54-5'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values('2321/78/54-9'); Query OK, 1 row affected (0.21 sec)Display all records from the table using select statement ...
Read MoreHow to create String object in Java?
You can create a String by -Assigning a string value wrapped in " " to a String type variable.String message = "Hello Welcome to Tutorialspoint";Creating an object of the String class using the new keyword by passing the string value as a parameter of its constructor.String message = new String ("Hello Welcome to Tutorialspoint");Passing a character array to the String constructor.char arr[] = {'H','e','l','l','o'}; String message = new String(arr);
Read MoreOrder VARCHAR records with string and numbers in MySQL
For this, use ORDER BY clause. Let us first create a table −mysql> create table DemoTable -> ( -> StudentCode varchar(20) -> ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('101J'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values('100A'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable values('100B'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values('101S'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('103M'); Query OK, 1 row affected (0.15 ...
Read MoreGet number of users of different type in MySQL?
Let us first create a table −mysql> create table DemoTable -> ( -> UserName varchar(20), -> UserType ENUM('New User', 'Registered User') -> ); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', 'New User'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values('David', 'New User'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values('Mike', 'Registered User'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values('Sam', 'New User'); Query OK, 1 row affected (0.10 sec)Display all records ...
Read MoreRound records with numbers in MySQL
To round number, use MySQL ROUND(). Let us first create a table −mysql> create table DemoTable -> ( -> Amount DECIMAL(10, 4) -> ); Query OK, 0 rows affected (1.18 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100.578); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(1000.458); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values(980.89); Query OK, 1 row affected (0.13 sec)Display all records from the table using select statement −mysql> select * from DemoTable;This will produce the following output−+-----------+ | Amount | ...
Read More