Tag Archives: oracle
Activate Expired Accounts – Oracle
I installed oracle couple of months back and set up users, however now i realized that the users were expired and in their grace period. Here is what it looked… Read more
How to connect to oracle database using OCI8 – PHP
In my previous post i demonstrated how to install OCI8 http://www.yoursearchbuddy.com/installing-oci8-on-linux In this post we will discuss how to connect to Oracle database using OCI8: First create a connection string:… Read more
Cron job to connect a perl script to Oracle
I encountered with a problem recently where my perl script that was connection to Oracle database was working fine if run manually, however when i added that script in the… Read more
Select or delete duplicate rows from a table
When it comes to database, there are various ways you can select or delete the duplicate rows from a table. Lets first focus on selecting the duplicate rows: This can… Read more
Create a read only user – Oracle
If you wish to create a user in Oracle that just have read permissions in the tables, then you must follow these steps: First Create a user, let’s say “prod”:… Read more
Query to see all oracle sessions
Here is a query to see all oracle sessions. You should be logged in as system administrator: SELECT s.inst_id, s.sid, s.serial#, p.spid, s.username, s.program FROM gv$session s JOIN gv$process p… Read more
Perl database connection
For database connectivity with perl we need module DBI DBI stands for database interface.This module creates a bridge between Perl and database.Perl is capable to perform verities of database operations… Read more
Any workaround for order by in Subqueries – Oracle?
I was totally stumped today when i was trying a simple query in Oracle, however just wasn’t able to get the solution. The only thing i wanted to do was… Read more
Connect to Oracle in R (Linux)
First thing first, you need to start the listener for the database you need to connect to in R. There are two ways to connect to Oracle: Using ROracle or… Read more
What a dumb “Oracle” website is..
Oracle might have acquired lot of companies, made best databases but i must say it has the most dumb website that i have ever seen. After browsing it for less… Read more
