Education Subscribe to Education
Get post author name – WordPress
While working with wordpress, you might want to do something with the post author. Here is how to get the author name: $postAuthor = $post->post_author; //$postAuthor have the Author Id… 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
Inserting test data in SQL Server
Thats the worst part for a developer, when a developer has to insert the test data in the database to test the unit test cases. There are various tools in… Read more
Delete a column from a data frame in R
Here is a quick tip to delete a column from a data frame in R: Lets assume our data frame is: > data code sector industry 1 901 Basic Industries… Read more
Tips to use data frame in R
Here are some tips to manipulate data frame in R: Lets say the data frame that we have is: > data code sector industry 1 901 Basic Industries Building and… Read more
Show mysql results vertically
Today while doing some sql queries, i came across a issue where i wanted to see all the columns of a table,however there were lot of columns inside my table,… 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
iptables in Linux
iptables is a tool used in linux distributions to control kernel’s netfilter’s firewall. To start off with there are three real “chains” which iptables uses: INPUT chain – used to… 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
Database Testing
In Database Testing we validate if the proper data is maintained at Backend. We also validate the Stored Procedure return the expected result. Database testing can be categories at the… Read more
