Skip to content

MullOverThing

Useful tips for everyday

  • Home
  • Guidelines
  • Popular
  • Miscellaneous
  • Helpful tips
  • Contributing
  • Blog
  • Home
  • Guidelines
  • Popular
  • Miscellaneous
  • Helpful tips
  • Contributing
  • Blog

  • March 11, 2019Contributing

    Can we use multiple aggregate functions in SQL?

    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…

    Read more
  • March 11, 2019Popular

    Why MongoDB is not good?

    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,…

    Read more
  • March 11, 2019Helpful tips

    How do you find deadlocks?

    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…

    Read more
  • March 11, 2019Popular

    How do I change the path of Tnsnames Ora?

    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…

    Read more
  • March 11, 2019Popular

    Can ForeignKey have default value?

    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…

    Read more
  • March 11, 2019Guidelines

    How do you create a table within a procedure?

    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…

    Read more
  • March 11, 2019Helpful tips

    How do I drop a database in SQL Server 2012?

    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…

    Read more
  • March 11, 2019Guidelines

    What is the maximum extension size of undo tablespace?

    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…

    Read more
  • March 11, 2019Blog

    When is index not used in where clause?

    When is index not used in where clause? Oracle not using index when > used in where clause. We have a relatively classic scenario where…

    Read more
  • March 11, 2019Blog

    What is SQL Ifnull?

    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.…

    Read more

Posts pagination

Previous 1 … 68,256 68,257 68,258 68,259 68,260 68,261 68,262 68,263 68,264 … 74,181 Next

Pages

  • Contact us
  • Disclaimer
  • Privacy Policy
  • Terms and Conditions

Copyright © 2021 mulloverthing.comPowered by Nutmeg

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok