Rohith

Creator of whiletrue.live.

SQL * Plus

SQL*Plus is a client terminal software allowing users to interact with Oracle server to manipulate data and data structures. Users type in SQL statements in SQL*Plus that send statements to Oracle server. Oracle server then validates and executes the statements on its databases. The query results are returned to SQL*Plus and displayed to the user.

Posted September 22, 2022 by Anusha and Rohith ‐ 2 min read

⌖ sql rdbms

Set Commands

Sets a system variable to alter the SQL*Plus environment settings for our current session, for example: Display width for data, Turn on HTML formatting, Enabling or disabling printing of column headings, Number of lines per page.

Posted September 22, 2022 by Anusha and Rohith ‐ 4 min read

⌖ sql rdbms set-commands

Parallelize() In Spark

Parallelize() is the SparkContext method used to create rdd from the list of elements.

Posted August 31, 2022 by Rohith ‐ 3 min read

⌖ apache spark bigdata distributed-system spark-fundamentals

ORDER BY Clause

The SQL ORDER BY clause is used to sort the data in ascending or descending order, based on one or more columns. Some databases sort the query results in an ascending order by default.

Posted September 22, 2022 by Anusha and Rohith ‐ 2 min read

⌖ sql rdbms order-by

GROUP BY Clause

The SQL GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups. This GROUP BY clause follows the WHERE clause in a SELECT statement and precedes the ORDER BY clause.

Posted September 22, 2022 by Anusha and Rohith ‐ 2 min read

⌖ sql rdbms group-by