Useful tips for everyday
Where is RMAN backup located? To display all backups: Connect RMAN to the target database as described in “Connecting to the Target Database Using RMAN.”…
How do I import a database into phpMyAdmin? Import or restore a database or table Log into phpMyAdmin. Select the destination database on the left…
How to configure PostgreSQL to install PostGIS? configure: error: could not find pg_config within the current path. You may need to try re-running configure with…
What is SQL Server audit? Auditing an instance of the SQL Server Database Engine or an individual database involves tracking and logging events that occur…
Can we pass table name as parameter in function? No you cannot pass a table name as variable to a User defined function as you…
How do I restore a specific table from a SQL Server database backup? To restore only specific tables/rows, following steps need to be executed: Start…
How do you add an attachment field in access? Add an attachment to a table With the table that contains your attachment field open in…
How to insert a row into a table? The promotion identification number is an identity column so its value is automatically populated by the SQL…
Does Oracle provide backup support? The Oracle Database Backup Service can be accessed from anywhere, at anytime, and from any Oracle database server connected to…
What is property in SQL? The IDENTITY property allows you to specify a counter of values for a specific column of a table. Columns with…