Useful tips for everyday
What is Dbid in Oracle? The Database Identifier (DBID) is an internal, uniquely generated number that distinguishes the target database from the rest of the…
Can I declare variable in view? You can’t declare variables in a view. Could you make it into a function or stored procedure? Edit –…
Can You Drop a datafile from a tablespace? Until Oracle Database 10g Release 2, Oracle did not provide an interface for dropping datafiles in the…
How use lateral join? You can use lateral subqueries with the LEFT OUTER and INNER join types, for example: FROM table1 LEFT OUTER JOIN LATERAL…
How do you create a copy of a database? We need to follow these steps to copy a database to another database: First, use the…
Does join give duplicate records? Join duplications This is not true: SQL joins will give you at least as many rows as the join specifies.…
How to create a read only user in PostgreSQL? To create a true read-only user with PostgreSQL 9.0+, run the following steps: If your read-only…
What causes a rounding error? Rounding errors are due to inexactness in the representation of real numbers and the arithmetic operations done with them. Digital…
How do I enable Named Pipes in SQL Server? Process Open the SQL Server Configuration Manager on the SQL Server. Expand SQL Server Network Configuration…
How do I get distinct on only one column? Adding the DISTINCT keyword to a SELECT query causes it to return only unique values for…