by Barry Allen | Apr 9, 2022 | Oracle, SQL
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... by Barry Allen | Apr 9, 2022 | Oracle, SQL
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... by Barry Allen | Apr 9, 2022 | Oracle, SQL
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... by Barry Allen | Apr 8, 2022 | Oracle, SQL
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... by Barry Allen | Apr 8, 2022 | Interview, Oracle, SQL
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... by Barry Allen | Apr 8, 2022 | ABAP, ABAP Beginner, Oracle, SAP, 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...