Does Oracle go for hard parse again if I truncate the table?...

Is OPENROWSET a "production-safe" method?...

Maintain referential integrity without FK...

Letting users "GRANT SELECT" without making them admins or giving them CONTROL permission...

Grant permission to trigger from owner account...

Is it allowed to write a SQL function in Oracle to return more than data types?...

Cloud SQL Postgres - Managing Database Users, Best Practices?...

The table sys.dm_tran_session_transactions is always empty...

Drop a role with privileges...

Optimizing a query with multiple IN...

Database user session gets created after session kill...

I have some VBA that opens a spreadsheet and imports data from Access, how do I lock the original an...

How to export & import only data in oracle 11g?...

Should I make an intermediary table to solve the problem of joining 6 tables in a query?...

Does deleting the rows from table also release space of large objects in CLOB or BLOB columns?...

ignored fields when importing data using impdp...

import oracle 11g database dump file into 18c XE , success import but can't find the data or the...

How to efficiently query a large database on a hourly basis?...

How can I get 0 as value in Count(field) when Group by value is not present in any row for fk_user_i...

How to resolve ORA-04042 and ORA-00942 errors when granting privileges?...

What is XA Transactions ? How to Enable XA Transactions for SQL Server 2016 on Windows...

Doubts to create connection string with DB2...

What is the difference between roles and privlages...

ORA-01919: role 'RESTRICTED_ROLE1' does not exist...

Can a non sysdba compile dbms_session?...

Oracle 12c - DBA_USERS table - does LAST_LOGIN mean last successful login, or last attempted login?...

How can I get the complete definition (sql) of system views like user_objects?...

Paralle backup threads in postgres...

shared_buffers in greenplum are per-segment or for all segments?...

What are the cases where someone would be storing Oracle DB object statistics...