# Life Wisdom & Significant
  • Selayang Pandang
  • Resume
  • Kajian Rutin

Database

Import .sql file into database schema in PostgreSQL

November 1, 2018 Muhammad Ghufron Leave a comment Database

Just wanna post snippet code import .sql file into particular database schema in PostgreSQL. Here is the command :

Continue reading


PostgreSQL Converting Epoch (date long) to Formatted Date (vice versa)

August 6, 2018 Muhammad Ghufron Leave a comment Database

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 […]

Continue reading


Sticky Code : Kill Process Session Database in PostgreSQL

September 19, 2017October 29, 2020 Muhammad Ghufron Leave a comment Database

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 […]

Continue reading


Drop all tables without drop schema in Oracle

April 25, 2015 Muhammad Ghufron Leave a comment Database

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.

Continue reading


Oracle failed login SYSDBA insufficient privileges

April 23, 2015October 31, 2020 Muhammad Ghufron Leave a comment Computer (General), Database

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 […]

Continue reading


Posts navigation

Older posts

Categories

  • College
  • Computer (General)
  • Data
  • Database
  • Islamic
  • JAVA Programming
  • JBPM
  • Liferay Portal
  • Linux
  • My Mind
  • Review Buku
  • Social Network Analysis
  • Vlog

Let's Share

facebooktwittergoogle_plusredditpinterestlinkedinmailby feather

Recent Post

  • Resensi Buku : Bicara Itu Ada Seninya – Oh Su Hyang July 13, 2022
  • Resensi Buku : Pendidikan Anak Dalam Islam July 11, 2022
  • Resensi Buku : Sejarah Islam yang Hilang June 12, 2022
  • Jalan – Jalan ke Pulau Belitung (Bagian 2) August 8, 2021
  • Memahami Konsep Data Driven Pada Sebuah Organisasi May 14, 2021

Recent Comment

  • gladieselmira on Memahami Konsep Data Driven Pada Sebuah Organisasi
  • ICT on Executing Another Method After Few Second in Java
  • slot on Bulk Delete Operation with Spring Data JPA and Spring MVC
  • riini on Sarjana dan Planning Selanjutnya
  • download lagu on Kumpulan Kisah Inspiratif Kick Andy

Tags

An Effective Live Application programming interface Belitung Clear Vision Data Driven Google OAuth 2.0 Gunadarma Haji hashmap Hibernate Islam Java JAVA Hibernate JAVA Programming Jboss Jbpm Json Liferay Portal linux Manajemen Informatika Maulid Nabi Muhammad SAW My Mind MySQL Object Relational Mapping Open Mind Oracle ORM Penulisan Ilmiah Perancangan Finansial postgresql Programming Psikologi python Review Buku Sejarah social network analysis Software Development spring Spring 3 Sticky Code Struts Swing Time Management Toleransi Beragama
    Life Wisdom & Significant. All rights reserved. Theme by Colorlib Powered by WordPress