the aspects of database usage not directly related to the insertion and extraction of information, such as security, configuration and performance tuning
I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change. …
sql sql-server database database-administrationAn update SQL query was executed on the server, which caused many problems later. How can I get the list …
oracle sql-update database-administrationThe following query: select cdate from rprt where cdate <= TO_CHAR(sysdate, 'YYYY/MM/DD-HH24-MI-SS-SSSSS') and ryg='R' …
sql oracle10g database-administrationHow to use H2 database's integrated managment frontend? For operations such as create table, alter table, add column, and so …
database h2 database-administrationI need to quickly (and forcibly) kill off all external sessions connecting to my oracle database without the supervision of …
oracle session sqlplus kill database-administrationI'm trying to create my own database using SQLPlus. So first I log into it as admin: sqlplus sys/sys_…
oracle sqlplus database-administrationI'm getting this error if i try to login as db user. If lsnrctl status is run i get the …
database oracle database-administrationWhen i tried to create a table in my User_DB schema i am getting an error as ORA-01658: unable …
oracle select database-administration tablespaceI Am using oracle 11g and SQL developer tool. When i tried to retrieve rows from db i am getting …
database sql oracle database-administrationI have a database in a local file that is used by a program. The program has limited functionality and …
sql-server database database-connection sql-server-express database-administration