Useful tips for everyday
Can we call a stored procedure inside a function in Oracle? You cannot execute a stored procedure inside a function, because a function is not…
How to update one table based on another? We need to update one table based on another. This can be solved using an UPDATE with…
What is a composite join? If one or more joins are involved, an outer composite table consists of the intermediate result rows from the previous…
Are double quotes allowed in JSON? Aside from double quotes, you must also escape backslashes if you want to include one in your JSON quoted…
How do I Change my Password in MySQL? Using the MySQL Databases Page to change the Password. On the MySQL Databases page scroll down to…
How do you use case when counting? CASE can be used in conjunction with SUM to return a count of only those items matching a…
How do I add more space to my VHD? Under the Hardware section select “Hard Drive” Select the Edit button. Click NEXT then select the…
What is participation and cardinality? Cardinality is a count of the number of times one entity can (or must) be associated with each occurrence of…
How to replication from master to slave in PostgreSQL? To make sure that data replication from the master to the slave database node works as…
How to create table inheritance in SQL Server? So, our Students table will have a constant PersonType value of 1, the Teachers table a value…