Just wanna post snippet code import .sql file into particular database schema in PostgreSQL. Here is the command :
Database
PostgreSQL Converting Epoch (date long) to Formatted Date (vice versa)
Epoch : The Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). Literally speaking the epoch is Unix time 0 (midnight 1/1/1970), but ‘epoch’ is often used as a synonym for […]
Sticky Code : Kill Process Session Database in PostgreSQL
Have you ever seen this error message when you are trying to delete particular DB ? This error message tells us that DB in used and cannot be dropped. And sometimes I feel little bit annoying because I don’t have much time to ask anyone who access / remote DB to close their connection. So what […]
Drop all tables without drop schema in Oracle
I just wanna post simple snippet script SQL in oracle. It used to drop all tables without drop schema. Open your SQL Editor (Im using SQLDeveloper). Run this script.
Oracle failed login SYSDBA insufficient privileges
When I trying to login as SysDBA in Oracle, I got this message : I asked my friend, and he has helped me to fix this problem (thank you very much to mas bogie XYBASE ), he said the problem is caused by “Root user can’t access the Oracle Environment Path”. Okay now I would […]