Useful tips for everyday
What is InnoDB Monitor output? When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output ( stderr…
How do I reclaim free space in Oracle? Here are the high-level steps that will be performed. Create an ASM Disk Group using the ASM…
Is SQL the greatest function? GREATEST() function in MySQL is used to find greatest values from given arguments respectively. If any given value is NULL,…
What does with recompile do in SQL? RECOMPILE – specifies that after the query is executed, its query execution plan stored in cache is removed…
Are joins associative? Inner and full outer joins are both commutative and associative, i.e. the following is fair for them: A [FULL | INNER] JOIN…
Can ORDER BY and WHERE be used together? Both GROUP BY and ORDER BY are clauses (or statements) that serve similar functions; that is to…
How do I clone AWS RDS? To clone an Aurora cluster owned by another AWS account Clone the cluster by specifying the full ARN of…
How to manage parent child relational rows in SQL? FROM UserType JOIN tblChild ON UserType.ParentId = tblChild.Id ) SELECT * FROM tblChild OPTION (MAXRECURSION 32767)…
How do you find the current SCN? Following are the way to check current SCN in Oracle Database: Fetch the current SCN number in v$database…
How do you find the average number of items sold daily? Divide your sales generated during the accounting period by the number of days in…