Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Matrices are nothing but it’s more than a collection of data elements arranged in a rectangular layout that is two-dimensional. In Java, an array with two dimensions can be considered as a matrix. As per the problem statement the task is replace the matrix elements by its square. Let’s deep dive into this article, to know how it can be done by using Java programming language. To show you some instances Instance-1 Suppose the original matrix is {{8, 3, 2}, {12, 7, 9}, {6, 4, 10}}; After replacing the matrix element by its square, the result matrix will be 64 ... Read More
As per the problem statement, we are going to find the file owner name in Java. The owner’s name here represents the owner of the PC in which file is being runned. To find the file owner in Java we will use the getOwner() method of the FileOwnerAttributeView class. FileOwnerAttributeView belongs to the java.nio class. Let’s deep dive into this article, to know how it can be done by using Java programming language. To show you some instances Instance-1 Suppose the given file location is “D:/saket.txt”. After checking for Owner name of the given file, the output will be − ... Read More
In this article we will see how to homogenize a point. Any point in the projective plane is represented by a triple (X, Y, Z), called homogeneous coordinates or projective coordinates of the point, where X, Y and Z are not all 0. The point represented by a given set of homogeneous coordinates is unchanged if the coordinates are multiplied by a common factor. As per the problem statement we have to homogenize a point by taking any common factor and multiplying it with the given points. Let’s start! To show you some instances Instance-1 Suppose the points are (10, ... Read More
In a given array with some random integer values, we have to find out the single digits available in the given array and print those single digit values as output. An array can contain positive or negative numbers irrespective of the number of digits in a number. As here all elements belong to numeric type. Note- Take a positive integer array. Let’s deep dive into this article, to know how it can be done by using Java programming language. To show you some instances Instance-1 Given Array= [1, 12, 3, 4, 10, 15]. The single digit elements present in the ... Read More
Factors such as data analysis and growth rate monitoring are very important when it comes to plotting stock charts. For any business to flourish and expand, the right strategy is needed. These strategies are built on the back of a deep fundamental research. Python programming helps us to create and compare data which in turn can be used to study a business model. Python offers several methods and functions through which we can plot graphs, analyse growth and introspect the sudden changes. In this article we will be discussing about one such operation where we will plot a stock chart ... Read More
We are given a positive integer of digits and the task is to calculate the count of odd and even digits in a number using PL/SQL.PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL.PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. Input int number = 23146579 Output count of odd digits in a number are : 5 count of even digits in a number are : 3Explanation − ... Read More
PL/SQL is oracle’s procedural language extension to SQL. PL/SQL allows you to mix SQL statements with procedural statements like IF statements. Looping structure etc, PL/SQL is the superset of SQL. It uses SQL for data retrieval and manipulation and uses its own statement for data processing.Pl/SQL program units are generally categorized as follows −Anonymous blockThis is a PL/SQL block that appears within your application. In many applications PL/SQL blocks can appear where SQL statements can appear. Such blocks are called Anonymous blocks.Stored proceduresThis is a PL/SQL block that is stored in the database with a name. Application programs are executing ... Read More
The Excel sheets where we can put some restrictions on the sheet are known as "protected sheets." In Excel, you may want to copy protected data to another sheet or within the same sheet at times. If we try to copy the data directly, then Excel will not allow us to copy the data. But we can use the tricks given in this tutorial to copy the data from a protected sheet. Read this tutorial to learn how we can copy data from a protected sheet in Excel. We can solve this task using these two methods. The first method ... Read More
Generally, in Excel, we can copy the content of a cell easily just by using the copy and paste function. But have you ever tried to copy the cell address of one cell from another? We can use the steps mentioned in this. Even though we can complete the task simply by using formulas, there are times when we need to use some interesting methods with the VBA application. Read this tutorial to learn how we can copy the current cell address to another location in Excel using the VBA application. We can copy the current cell address to other ... Read More
Conditional formatting is one of the most commonly used functions in Excel. Generally, conditional formatting can be used to make patterns and highlight the data based on the cell value. We can create conditional formatting based on the rules, such as cell value and its range. Creating conditional formatting for every need we have can be a time-consuming and lengthy process. So, we can copy the condition formatting that is already there into the same workbook or another workbook. Read this tutorial to learn how to copy conditional formatting rules to another worksheet or workbook in Excel. We can complete ... Read More