A function is a special type of predefined command set that performs some operation and returns a single value. Functions operate on zero, one, two or more values that are provided to them. The values that are provided to functions are called parameters or arguments....
INSTR() :
This function in MySQL is used to return the location of the first occurrence of a substring within a given string....
As a DBA, you might need to copy the objects and the content of specific tables from a database to another one in the same instance or in any different SQL instance. You might think of using Insert Into Select statement in MS SQL Server but it will not be useful in scenarios such as transferring few tables from a production database to a development one for testing or troubleshooting. Also, this depends on the number of tables, size, and available space in the database. If the total size of the tables is more than 50% of the total size of the database than the recommended method to use is the backup and restore the database....
SQRT() is function in MySQL is used to return Returns the square root of a given non-negative number. If the number is negative then it returns NULL....
In this article, we are going to cover DateSerial() and DateValue() Function in MS Access with examples and will cover DateSerial and DateValue query with output....
Duplicate values in any table might be due to the poor table design or unwanted data from other sources. To delete the duplicate data from the table in SQL Server, follow the below steps –...
The CREATE INDEX statement will create indexes in tables. Indexes are used for data procurement from the databases faster. The users cannot see the indexes, they are running in the background of queries, used to speed up searches/queries....
Declare Local Temporary Table statement used to create a temporary table. A temporary table is where the rows in it are visible only to the connection that created the table and inserted the rows....
1. Oracle: Oracle is commercial software developed by Oracle Corporation. Oracle widely uses RDBMS. Oracle allows quick and safe store and retrieval of data. It is used for running Online Transaction Processing and Data Warehousing. Oracle runs on the most major operating systems like Mac OS, Unix, Windows and Linux. Oracle has a networking stack, allows applications from a different platform to communicate with the Oracle easily....
1. IBM DB2 :
IBM DB2 is a relational database which was developed by IBM in 1983. It is considered as a family of database management products which are build for AI. It has enhanced capabilities for performing transactions. It works on the principle of ACID and has high flexibility and performance. It has efficient backup facilities and is considered very secure. It is extremely reliable and is supported by Linux, Unix and Windows operating systems. It has a commercial license and has high scalability....
Discretionary Privileges in Access Control:Discretionary Access Control is a mechanism that allows the owner of a resource to control who has access to that resource and what actions they can perform on it. The term “discretionary” implies that the owner has the discretion to decide who is granted access and what privileges they are granted....
