Sunidhi Bansal

Sunidhi Bansal

809 Articles Published

Articles by Sunidhi Bansal

Page 78 of 81

Count no. of characters and words in a string in PL/SQL

Sunidhi Bansal
Sunidhi Bansal
Updated on 15-May-2020 2K+ Views

We are given a string of any length and the task is to calculate the count of characters and words in a string 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.In PL/SQL block, we have DECLARE block which is used to declare the variables used in programming and we have BEGIN block where we write the logic for the ...

Read More

Convert distance from km to meters and centimeters in PL/SQL

Sunidhi Bansal
Sunidhi Bansal
Updated on 15-May-2020 715 Views

The task is to convert the distance from kilometers to meters and centimeters in PL/SQL.PL/SQL is the extension of SQL which combines the Data manipulation of SQL with the working of procedural language.According to the problem we should have distance in kilometers whose value we have to convert in meters and centimeters.As per the conversion rule −1km = 1000 meters1km = 100000 centimetersAccording to this conversion rule we want the distance to be converted by a logic in PL/SQL.ExampleInput: kilometer = 10 Output: meter = 10000    Centimeter = 1000000 Input: kilometer = 9 Output: meter = 9000    Centimeter ...

Read More

Data types ranges and their macros in C++

Sunidhi Bansal
Sunidhi Bansal
Updated on 23-Mar-2020 346 Views

Given the task is to find the memory range of the different data types, that what range of value a data type can store the value from minimum value to maximum value. There is memory range of data type from in which value of data can be stored. It is difficult to remember the large range of value so C++ has macros for represent these numbers, from macros these large numbers can be directly assigned to variable without typing the whole Number range. Example 'char'(signed) is character data type and has a range of -128 to +128 and ...

Read More

list operator = in C++ STL

Sunidhi Bansal
Sunidhi Bansal
Updated on 05-Mar-2020 358 Views

Given is the task to show the functionality list operator = function in C++ in STL.What is List in STL?List are containers that allow constant time insertion and deletion anywhere in sequence. List are implemented as doubly linked lists. List allow non-contiguous memory allocation. List perform better insertion extraction and moving of element in any position in container than array, vector and deque. In List the direct access to the element is slow and list is similar to forward_list, but forward list objects are single linked lists and they can only be iterated forwards.What is use of operator = ?This ...

Read More

Ratio_less () function in C++

Sunidhi Bansal
Sunidhi Bansal
Updated on 28-Feb-2020 149 Views

Given is the task to show the working of ratio_less () function in C++.The function ratio_less() checks if the value of ratio1 is less than ratio2. It returns a Boolean constant “value” which returns true if ratio1 is less than ratio2 else returns false.ExampleInput: 1/3 and 3/9 Output: 1/3 is less than 3/9. Input: 1/4 and 1/8 Output: 1/4 is not less than 1/8.SyntaxTemplate ratio_lessParametersThis function accepts two template parameters one is ratio1 and another one is ratio2 which are to be compared.ExplanationIn this function, if the value of ratio1 is less than the value of ratio2 then this ...

Read More

hypot( ), hypotf( ), hypotl( ) in C++

Sunidhi Bansal
Sunidhi Bansal
Updated on 28-Feb-2020 309 Views

In this article we will be discussing the working, syntax and examples of hypot( ), hypotf( ), hypotl( ) function in C++.hypot( ) functionThis function is used to compute the hypotenuse of a right angled triangle. This function returns the square root of sum of square of two variables. It is a function of header file.What is hypotenuse?Hypotenuse is the longest side of the right angle triangle. Below is the graphical representation of a hypotenuse in a right angle triangle.In above figure AC side of the triangle is a hypotenuse.The formula to calculate hypotenuse is −$$H = \sqrt{x^2+Y^2}$$SyntaxData type ...

Read More

list begin( ) and list end( ) in C++ STL

Sunidhi Bansal
Sunidhi Bansal
Updated on 26-Feb-2020 643 Views

Given is the task to show the functionality list begin( ) and list end( ) function in C++ in STL.What is List in STLList is a data structure that allows constant time insertion and deletion anywhere in sequence. Lists are implemented as doubly linked lists. Lists allow non-contiguous memory allocation. List perform better insertion extraction and moving of element in any position in container than array, vector and deque. In List the direct access to the element is slow and list is similar to forward_list, but forward list objects are single linked lists and they can only be iterated forwards.What ...

Read More

Elements present in first array and not in second using STL in C++

Sunidhi Bansal
Sunidhi Bansal
Updated on 20-Jan-2020 245 Views

We have two arrays, the task is to compare the two arrays and find the numbers present in first array but not in the second array, using Standard Template Library (STL) in C++.ExampleInput: array1[ ] = {1, 2, 3, 4, 5, 7} array2[ ] = {2, 3, 4, 5, 6, 8} Output: 1, 7 Input: array1[ ] = {1, 20, 33, 45, 67} array2[ ] = {1, 12, 13, 114, 15, 13} Output: 20, 33, 45, 67Approach used in the below program is as follows −In this program we want to find the elements which are present in the first ...

Read More

Product of non-repeating (distinct) elements in an Array in C++

Sunidhi Bansal
Sunidhi Bansal
Updated on 20-Dec-2019 273 Views

We are given with an array of repeating or duplicate elements and the task is to find the product of all those elements which are non-repeating or distinct in the given array and display the results.ExampleInput-: arr[] = {2, 1, 1, 2, 3, 4, 5, 5 } Output-: 120 Explanation-: Since 1, 2 and 5 are repeating more than once so we will take them into consideration for their first occurrence. So result will be 1 * 2 * 3 * 4 * 5 = 120 Input-: arr[] = {1, 10, 9, 4, 2, 10, 10, 45, 4 } ...

Read More

Program for Mobius Function in C++

Sunidhi Bansal
Sunidhi Bansal
Updated on 20-Dec-2019 545 Views

Given a number n; the task is to find the Mobius function of the number n.What is Mobius Function?A Mobius function is number theory function which is defined by$$\mu(n)\equiv\begin{cases}0\1\(-1)^{k}\end{cases}$$n=  0 If n has one or more than one repeated factorsn= 1 If n=1n= (-1)k  If n is product of k distinct prime numbersExampleInput: N = 17 Output: -1 Explanation: Prime factors: 17, k = 1, (-1)^k 🠠(-1)^1 = -1 Input: N = 6 Output: 1 Explanation: prime factors: 2 and 3, k = 2 (-1)^k 🠠(-1)^2 = 1 Input: N = 25 Output: 0 Explanation: Prime factor is ...

Read More
Showing 771–780 of 809 articles
Advertisements