Amit Diwan has Published 109 Articles

Cursors in Oracle DBMS

Amit Diwan

Amit Diwan

Updated on 20-Jun-2020 08:53:39

4K+ Views

When a SQL statement is executed in Oracle, the temporary context area is created. This area contains all the relevant information relating to the statement and its execution. The cursor is a pointer to this context area and allows the PL/SQL program to control this area.There are two types of ... Read More

Unary or Recursive Relationship

Amit Diwan

Amit Diwan

Updated on 20-Jun-2020 08:19:28

5K+ Views

When there is a relationship between two entities of the same type, it is known as a recursive relationship. This means that the relationship is between different instances of the same entity type.Some examples of recursive relationship can be shown as follows −An employee can supervise multiple employees. Hence, this ... Read More

Mathematical Functions in SQL

Amit Diwan

Amit Diwan

Updated on 20-Jun-2020 07:55:29

13K+ Views

Mathematical functions are very important in SQL to implement different mathematical concepts in queries.Some of the the major mathematical functions in SQL are as follows −ABS(X)This function returns the absolute value of X. For example −Select abs(-6);This returns 6.MOD(X, Y)The variable X is divided by Y and their remainder is ... Read More

Align flex items in the start on different screen sizes in Bootstrap

Amit Diwan

Amit Diwan

Updated on 18-Jun-2020 12:23:08

66 Views

To align flex items on small, medium, large and extra large screen size, use the justify-content-*-start class.Let us see first for small screen size −   Interface   Packages   Multithreading In the same way, implement it for medium, large and extra large screen size like the following −justify-content-md-start: Medium ... Read More

Add top rounded corners to an element in Bootstrap 4

Amit Diwan

Amit Diwan

Updated on 18-Jun-2020 12:21:30

375 Views

To add top rounded corners to an element, use the rounded-top class in Bootstrap 4.I have taken div as the element −Let us learn how to add top rounded corners to an element −ExampleLive Demo       Bootstrap Example             ... Read More

Set a border to an element in Bootstrap to indicate information

Amit Diwan

Amit Diwan

Updated on 18-Jun-2020 12:18:29

53 Views

To set a border indicating information, use the border-info class.To implement it −   Information Let us see an example to implement the border-info class −ExampleLive Demo       Bootstrap Example                             .one {       width: 200px;       height: 240px;       margin: 40px;     }             Rectangle with a border indicating information:     Information  

Remove borders from an element in Bootstrap

Amit Diwan

Amit Diwan

Updated on 18-Jun-2020 12:15:04

3K+ Views

Use the border-0 class in Bootstrap 4 to remove all borders from an element in Bootstrap 4 −   no border Above, we have the div class to no-border class and this allow us to remove the borders from the element.Let us see an example to implement the border-0 class ... Read More

Bootstrap 4 .flex-*-fill class implementation

Amit Diwan

Amit Diwan

Updated on 18-Jun-2020 09:58:51

139 Views

Use the flex-*-fill class to set the flex items to have equal width on different screens as shown in the below code snippet −For Small Width Screen   A   B   C For Medium Width Screen   A   B   C The following is an example to implement the ... Read More

Show flex items right aligned and horizontally in Bootstrap

Amit Diwan

Amit Diwan

Updated on 18-Jun-2020 08:00:01

95 Views

If you want to display flex items right aligned, horizontally and reversed, then use the flex-row-reverse class.Use the class like the following code snippet −   ONE   TWO   THREE The following is an example to show reverse order of flex items −ExampleLive Demo       ... Read More

Bootstrap 4 .flex-wrap-reverse class

Amit Diwan

Amit Diwan

Updated on 18-Jun-2020 07:55:11

218 Views

Use the flex-wrap-reverse class in Bootstrap 4 to wrap flex items and in reverse order.Here is the difference between flex-wrap and flex-wrap-reverse −Set wrap-flex-reverse as in the following code snippet −   Rank 1   Rank 2   Rank 3   Rank 4   Rank 5 You can try to ... Read More

Advertisements