Category: Oracle

  • MSQL String Functions

    MySQL provided various functions to interact and modify the strings passed via arguments or fetched from tables. This article will go through all the available MSQL String Functions. Before that, let’s understand how exactly a string is treated in MySQL. MySQL String When a binary string is passed to a string function as an argument,…

  • MySQL Math Functions

    In this article, we will discuss all available MySQL Math Functions. Math ABS() function MySQL’s abs() function is a Math function. The absolute value of a number is calculated using this function. Syntax: Select abs(num); Output: 11 Math ACOS() function The arc cosine of X, or the value whose cosine is X, is returned If…

  • MySQL Date/Time Functions

    MySQL Date/Time For storing a date or a date/time value in MySQL, the following data types are available: DATE – format YYYY-MM-DD DATETIME – format: YYYY-MM-DD HH:MI:SS TIMESTAMP – format: YYYY-MM-DD HH:MI:SS YEAR – format YYYY or YY DATE() function The date portion of a date or datetime expression is extracted. Example: mysql> SELECT DATE(‘2022-12-30 01:02:03’); -> ‘2022-12-30’  …

  • Table operation in MySQL

    Introduction In the structural format, a table is used to organize data in the form of rows and columns and is used for both storing and presenting records. Worksheets in a spreadsheet application are like this. Three components are required for a table formation: The table’s name Names of fields Each field’s definitions CREATE Table…

  • MySQL Interview Questions

    MySQL Theoretical Interview Questions Below is a list of the most often asked MySQL interview questions and answers. 1) Which programming language was MySQL written in? Ans: MySQL is written in C and C++ and  yacc-based SQL parser is written in yacc. 2) What are MySQL’s technical specifications? Ans: MySQL’s technical specifications are as follows: Structure…

  • Difference between Open SQL and Native SQL

    Preface – This post is part of the ABAP Beginner series. Introduction There are two forms of SQL used in the ABAP/4 programming language: OPEN SQL and NATIVE SQL Regardless of the database platform used by the R/3 system, Open SQL allows you to access the database tables stated in the ABAP dictionary. In an ABAP/4…

  • Difference between SQL Server and MySQL

    Introduction For high-end applications, both MYSQL and SQL Server deliver equivalent speed and performance. Both can host several databases on a single server. To sort data and speed up the performance, they use indexes. On both the RDBMS and the Windows system, different SELECT, INSERT, DELETE, and UPDATE queries were run and the execution time…

  • Difference between SQLite and MySQL

    Introduction The database is an essential component of any website or development project. On the market, there are various databases to choose from. Both SQLite and MySQL are widely used open-source databases. We’ll break down the key differences between the two in this article to assist you to comprehend the two – SQLite versus MySQL.…

  • Difference between No SQL and SQL

    Introduction In today’s industry, many databases are utilized. There are SQL databases and NoSQL databases among the databases. The traditional database is a SQL database system that represents data and relationships using a tabular relational paradigm. The NoSQL database is a newer database that uses a different technique for storing and retrieving data than relational…

  • Difference between Mongo DB and MySQL

    Introduction The two most common databases for enterprise applications are MySQL and MongoDB. Even though both databases are free and open-source, they have significant variances. Based on several characteristics, we’ll compare the differences between MySQL and MongoDB database systems. What is Mongo DB MongoDB is a document-oriented, open-source, cross-platform NoSQL database that offers excellent performance,…