Useful tips for everyday
Can we use multiple aggregate functions in SQL? Multiple aggregate functions in one SQL query from the same table using different conditions. I’m working on…
Why MongoDB is not good? One of the downsides of MongoDB is that it doesn’t support transactions. Though fewer and fewer applications are requiring transactions,…
How do you find deadlocks? A deadlock occurs when two processes are trying to update the same record or set of records, but the processing…
How do I change the path of Tnsnames Ora? Answer On the desktop Right-click on My Computer and select Properties > Advanced tab. Click the…
Can ForeignKey have default value? Yes, you can define a column with a default value of 0 as a Foreign Key. However, for the constraint…
How do you create a table within a procedure? 1 Answer. EXECUTE IMMEDIATE ‘create table table_2 as select col1, col2, col3, col4 from table_1’; If…
How do I drop a database in SQL Server 2012? Using SQL Server Management Studio In Object Explorer, connect to an instance of the SQL…
What is the maximum extension size of undo tablespace? Undo tablespaces have some additional properties beyond those of permanent tablespaces. There can be multiple undo…
When is index not used in where clause? Oracle not using index when > used in where clause. We have a relatively classic scenario where…
What is SQL Ifnull? The IFNULL function specifies a value other than a null that is returned to your application when a null is encountered.…