After you unzip all the client files, make sure you set the environments variable correctly in your bash file. Generally its your .bashrc file:

ORACLE_HOME=/location of your sqlplus client directory

//In my case i installed under /opt directory.
//By default it makes the directory as instantclient_11_2
// (I installed Oracle 11g r2).
//Then i did mv instantclient_11_2 oracle

Thus now:

ORACLE_HOME= /opt/oracle

//Add $ORACLE_HOME to PATH

PATH=.:$ORACLE_HOME
export PATH
export ORACLE_BASE=/opt
export ORACLE_HOME
export LD_LIBRARY_PATH=$ORACLE_HOME:$ORACLE_HOME/lib

This should solve your issue, however after this you might again get error: sqlplus: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

To resolve this error you need to install libaio1 package:  

(libaio1 - Linux kernel AIO access library - shared library)

# apt-get install libaio1

After the installation, you can connec to to sqlplus:

# ./sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 3 11:56:56 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: 

that is you are doing some thing like this

Client c = new Client();
c.open();
c.SomeMethod(); //one way method
c.Close(); //You will have to wait here untill the calls gets completed

so in this case you will need to either hook the close fiunction using some delegate or close the connection in the end of the whole functionality.

First thing you need to do is create a custom field under add post section with any name you wish, but let’s say you name it as “Thumbnail”.

Now in the value put the image location (http://www.example.com/imageFolder/thumbnail.jpg). So now you have what you need to show thumbnail for your post.

Do this in you page where you wish to show posts and their thumbnail:

$img = get_post_custom_values("Thumbnail");
if($img[0]){
	echo "<img src='$img[0]' height='75' width='75' alt='$post->post_title'  />
                $post->post_title";
}

You can show multiple posts with thumbnail. We will take my earlier post as reference http://www.yoursearchbuddy.com/post-category-wordpress :

<table>
	<?php $recent = new WP_Query("cat=categoryId&showposts=numberOfPost");
	      while($recent->have_posts()) : $recent->the_post();
	?>
		<tr>
			<?php
				$img = get_post_custom_values("Thumbnail");
				if($img[0]){
					echo "<td><img src='$img[0]'  alt='$post->post_title'
						  title='$post->post_title' /></td>";
				}
			?>
			<td>
				<a href="<?php the_permalink() ?>" rel="bookmark">
					<?php the_title(); ?>
				</a>
			</td>
		</tr>
		<?php endwhile; ?>
</table>

<ul>
< ?php $recent = new WP_Query("cat=categoryId&showposts=postNum"); while($recent->have_posts()) : $recent->the_post();?>
< ?php
	echo "<li>";
		<a href="<?php the_permalink() ?>" rel="bookmark">
			< ?php the_title(); ?>
		</a>
	echo "";
< ?php endwhile; ?>
</ul>

$postAuthor = $post->post_author;
//$postAuthor have the Author Id now

$curauth    = get_userdata(intval($postAuthor));
$authName = $curauth->user_login;

//$authName is the author name of the post

So if you are updating a table, and at the same time another T-SQL is issued to query the table with nolock as hint, then it will ignore the updates and give you the data which is there in the server.

This can be harmful if you are working on some sensitive data, however if you are working on some table say

SELECT COUNT(1) FROM Table1 WITH (NOLOCK)

Then it should not matter unless a huge number of records gets deleted or inserted in the table.

Lets first focus on selecting the duplicate rows:

This can be done in various ways:

Solution 1:

select columnName, count(columnName) as cnt
from tableName
group by columnName
where cnt>1

//columnName is the column that you are checking for duplicates

Solution 2:

select columnName , count(columnName ) as cnt
from tableName
group by columnName
order by cnt desc

Solution 3:

select columnName
from tableName
group by columnName
having count(*) > 1

Now lets see how can we delete the duplicate rows from a table:

Solution 1:

//In this solution we create a new table, with only distinct rows and then
deleting the old table and changing the new table name to the old table
name. However, in this way the primary key gets dropped from the table:

Step 1:

create table new_table as
select * from old_table where 1 group by [column to remove duplicates by];

Step 2: delete delete the old table

drop table old_table;

Step 3: rename the new_table to the name of the old_table

rename table new_table to old_table;

Solution 2:

// This solution doesn't require what all we did and restores
the primary keys

ALTER IGNORE TABLE tableName ADD UNIQUE INDEX(columnName);

If you wish to delete duplicates based on more than one index do:

ALTER IGNORE TABLE tableName ADD UNIQUE INDEX(columnName1,columnName2);

So, if your movie file name is abc.avi, then create another file abc.srt and open the file in notepad or any text editor and content should be like

0
00:00:34,133 --> 00:00:37,159
[man] I am going
to tell you a story now.

1
00:00:37,236 --> 00:00:39,727
But as any good storyteller knows,

This will show line

[man] I am going
to tell you a story now.

From 00:00:34,133 to 00:00:37,159

and is at index 0, that is first subtitle in the movie.

Have fun.