Google has launched its Indian music search which is the best music search i have come across the internet.All the other music search has either limited songs or songs that do not match the search criteria selected by users.Currently the Google music search is for hindi songs and the english version is yet to be released.
The tagline for this search is " Search for artists, albums or songs ".Currently the collections of hindi songs are their music partners in.com, saavn and saregama . The search displays a thumbnail of music poster with recent movie releases on the landing page.
The search powers bollywood songs , traditional songs , albums , song by various artists and the users can even search by the title of the song.Thumbs up to the Google music search where music search is made simpler.Lets hope the English version would be available soon
The link to the site is ( here )
Wednesday, November 3, 2010
Sunday, October 31, 2010
Query to display timestamp along with date component
As most of us are aware what a Sysdate Function performs , it does return a DATE value when you query the current system date . The Sysdate is a powerful function used very often when you want to consider the system date in various coding practices.If one wants the function to return a immediate next days date then just add a 1 to the sysdate as ( sysdate + 1 ) .This will return the immediate next day's date.
Usage : Select sysdate from dual ;
Coming to the Sql query to see the time stamp component , you need to convert the sysdate format into character specifying what format of date and time you want to see.
Solution : Select to_char ( sysdate , ' DD-MON-YYYY HH24:MI:SS ' ) from dual ;
The result would be similar to this :
The Sysdate includes the timestamp component also but while displaying it only shows the date component and when to convert that using to_char function you could see the time component also.
To exclude the time component from sysdate function ,
use - Trunc ( sysdate )
The above function truncates the time component and returns only date component .
Usage : Select sysdate from dual ;
Coming to the Sql query to see the time stamp component , you need to convert the sysdate format into character specifying what format of date and time you want to see.
Solution : Select to_char ( sysdate , ' DD-MON-YYYY HH24:MI:SS ' ) from dual ;
The result would be similar to this :
The Sysdate includes the timestamp component also but while displaying it only shows the date component and when to convert that using to_char function you could see the time component also.
To exclude the time component from sysdate function ,
use - Trunc ( sysdate )
The above function truncates the time component and returns only date component .
Friday, October 22, 2010
Download Missing Windows .dll files immediately - Dlldump
This is most common error you often see that a single or multiple (.dll) files are missing or corrupt when you have installed the application software or any other software that you use.The error could also be your system supporting dll files corrupt.
DLL - stands for dynamic link library which plays a major part in windows operating system.I had installed one software ,which showed.dll was missing . So i did a small research and found a cool site which holds large collection of dll files , and that s DllDump.com
DllDump.com - search for the dll file and download it immediately , the reason why am using dlldump is that it allows immediate download option for user rather than misleading users with download here ,download there which the other sites normally do.Link to the site is ( here )
screen shot of dlldump website :
Example Error : The program can’t start because MSVCR71.dll is missing from your computer. Try reinstalling the program to fix this program
Solution : After download , whats next ? where do i place the downloaded dll files ?
- Look for folder named system32, its located at/WINDOWS/ folder or use a folder search option in windows .
- Place the file in system32 directory and then re-start your application , if not re-boot /re-start your computer.Hope this works.
Tip :
Registering Dll file :
Type the following on the Windows Command Prompt
After that restart / reboot the application or system.
Just for your information on Unregistering the dll :
DLL - stands for dynamic link library which plays a major part in windows operating system.I had installed one software ,which showed
DllDump.com - search for the dll file and download it immediately , the reason why am using dlldump is that it allows immediate download option for user rather than misleading users with download here ,download there which the other sites normally do.Link to the site is ( here )
screen shot of dlldump website :
Dll Dump.com snapshot |
Example Error : The program can’t start because MSVCR71.dll is missing from your computer. Try reinstalling the program to fix this program
Solution : After download , whats next ? where do i place the downloaded dll files ?
- Look for folder named system32, its located at
- Place the file in system32 directory and then re-start your application , if not re-boot /re-start your computer.Hope this works.
Tip :
- For 32 bit Windows : use - C://WINDOWS/system32
- For 64 bit Windows : use - C://WINDOWS/SysWOW64
Registering Dll file :
Type the following on the Windows Command Prompt
regsvr32.exe Your_Dll_file.dll | >
After that restart / reboot the application or system.
Just for your information on Unregistering the dll :
regsvr32.exe /u Your_Dll_file.dll | >
Friday, October 8, 2010
A small difference in usage of " if - else if - else " in pl/sql , vb , Unix
The underlying logic of all the programs are same , only there is slightly change in their syntax and usage.I had worked on VB 6 past so always in that mode whenever using the other languages like PL/SQL .As i was working on "if-then-else " for pl/sql and found that it was flashing the syntax error . There is a small difference of this usage in three languages .
The following are the differences of IF-THEN-ELSE used in VB , PL/SQL and UNIX shell scripts :
1) VB :
if ( condition ) then
some_statements
else if ( condition )
other_statements
end if
2) PL/SQL :
if ( condition ) then
some_statements ;
elsif ( condition )
other_statements ;
end if ;
UNIX :
if ( condition ); then
some_statements
eif ( condition );
other_statements
The following are the differences of IF-THEN-ELSE used in VB , PL/SQL and UNIX shell scripts :
1) VB :
if ( condition ) then
some_statements
else if ( condition )
other_statements
else
final_statementsend if
2) PL/SQL :
if ( condition ) then
some_statements ;
elsif ( condition )
other_statements ;
else
final_statements ;end if ;
UNIX :
if ( condition ); then
some_statements
eif ( condition );
other_statements
else
final_statements
Monday, October 4, 2010
The feature I wish my smart phone had !
Nowadays everyone s crazy about smart phones , people tend to see others phone and think why didnt i have those features in my phone ? Android is fighting with Symbian and MeeGo is new baby to be born, watching those two fight lets wait for new features . Wat so ever the final downline for all these are Features , features and Features that your smart phone had !!!
The feature i wish my smart phone had :
The feature i wish my smart phone had :
- Automatic Voice Translator : Feels good to hear but that is possible in near future , afterall its Technology Boss , A smart phone which can translate to any language on the go without having to worry much about the unknown languages of the world.Need to speak to a Japanese ,just speak English and the rest of conversion should be done by smart phone.
- Audio-Video : The basic feature with powerful touch , When a person call s , His/Hers recorded original voice cum video should be the ringing tone present in smart phone
- Everything in One-Touch : One-touch Mail , One-Touch internet , One-touch answering to call ,One-touch avoiding of calls , One-touch music , One-touch video , One-touch radio , One-touch games , One-touch chatting , One-touch shopping , One-touch payment , One-touch fund transfer , One-touch love and last One-touch smart phone
- Mood Changer : From Angry , Sad , Frustrated , Bad to Happy and smiling mood . The moment you look at your smart phone , all the negative behaviour turns positive there by increasing Life span ( ha ha )
- Solar cum Electric charger : Dual charging options either by solar energy or by electrical energy , alternative for " save Electrical Energy "
- Friendship Express : Connect with anyone anywhere to any corner of the world with smart phone thereby " bringing the World Closer " .
- Simple Slim and Trendy : Light weight , simple and cool looking phone which should be a trend setter.
Friday, October 1, 2010
Creativity And Negativity go side by side
Creativity , as the name suggests is nothing but creating things that does not exists. Its something like giving a life to anything.Most animations are a product of creativity where an animal speaks to a bird or a snake takes to a mongoose. This can sometime be related to dreaming .One powerful aspect of dreaming is to reach the extreme corners of the world or the places which you have not come across with the power of imagination.
On the other hand Negativity is something like opposing , or thinking the reverse always.The one common thought that describes Negativity is to question oneself like What if ? What if i don't ? . Here more often one think that we cannot achieve anything because of the fear of failure that strikes most of the minds.
There is a lot of possibility that both go hand in hand sometimes which always has a real time impact , take a real time consideration that strikes ones mind, say you got a creative thought of jumping from a flying plane which is too high and without even thinking negatively you take a fall from plane and end up crashing on land creatively.If you had got a negative thought at that time of falling ,then you would carry a parachute along and then you could land safely.
From above thoughts sometimes think negatively along with creativity and see how success could follow you . This is applicable to real life experiences also ,may it be in field of business , artwork or anything for that matter.The only mantra to think here is "Be Negeto-creative" and change the way of thinking
On the other hand Negativity is something like opposing , or thinking the reverse always.The one common thought that describes Negativity is to question oneself like What if ? What if i don't ? . Here more often one think that we cannot achieve anything because of the fear of failure that strikes most of the minds.
There is a lot of possibility that both go hand in hand sometimes which always has a real time impact , take a real time consideration that strikes ones mind, say you got a creative thought of jumping from a flying plane which is too high and without even thinking negatively you take a fall from plane and end up crashing on land creatively.If you had got a negative thought at that time of falling ,then you would carry a parachute along and then you could land safely.
From above thoughts sometimes think negatively along with creativity and see how success could follow you . This is applicable to real life experiences also ,may it be in field of business , artwork or anything for that matter.The only mantra to think here is "Be Negeto-creative" and change the way of thinking
Tuesday, September 28, 2010
Query to Check the PL/SQL and Oracle Database Version
It becomes a necessity to sometimes check the version of Oracle database being used or to check the version of PL/SQL being used.To check which Oracle database you are working on and also to check which PL/SQL release , the query used :
This query can be tested on sql*Plus , SqlDeveloper or any other query executable tools.Along the above version details you could see the CORE version , TNS version and NLSRTL version
The Complete query result would look like this :
( click on the image to expand )
select * from v$version ; |
This query can be tested on sql*Plus , SqlDeveloper or any other query executable tools.Along the above version details you could see the CORE version , TNS version and NLSRTL version
The Complete query result would look like this :
( click on the image to expand )
Lsnrctl : error loading shared libraries libnnzll.so
The main problem causing this error is that the SElinux on Rhel 5 is blocking the listener to start the Listener control services ( lsnrctl ) . I had encountered this problem when i was starting the database for Oracle E-Business suite applications.After doin a small research i could get the solution to this particular problem.
Error : lsnrctl : error loading shared libraries : /directories/libnnzll.so : cannot restore segment prot after reloc : permission denied
Cause : The SElinux of redhat preventing the lsnrctl service to start
Solution : set the SElinux to Permissive and then start the lsnrctl service , this will solve the issue.
Steps : at Root , use the following commands
Error : lsnrctl : error loading shared libraries : /directories/libnnzll.so : cannot restore segment prot after reloc : permission denied
Cause : The SElinux of redhat preventing the lsnrctl service to start
Solution : set the SElinux to Permissive and then start the lsnrctl service , this will solve the issue.
Steps : at Root , use the following commands
- getenforce
- setenforce 0
- getenforce
Wednesday, September 22, 2010
Popuri - a tool to check link popularity
I came across this site from one of the forums as i was trying to check the google page rank of my blog.There are quite a few tool to check rankings but i found this site simple and cool.This website is a altogether tool to check link popularity and ranking of your site or blog by just entering a valid url .
What is popuri ?
- It is a tool to check link popularity on any sites based on its ranking . You can check the sites or blogs google page rank , the alexa ranking of your site and quite a few others like complete rank , quantcast rank , google yahoo and live search backlinks , social bookmarks and the last one comes from subscribers.
You can even show the popularity of your site by displaying the badge of popuri on your blog or website.This badge gives the complete detailed stats of rankings and backlinks of your site or blog.
I was eager to know who is the first in alexa ranking and it was exactly what i guessed it , the number one on alexa ranking is currently google followed by facebook and so on . Alexa is part of amazon.com and amazon is in 14th rank on alexa .
The link to this site is ( here )
What is popuri ?
- It is a tool to check link popularity on any sites based on its ranking . You can check the sites or blogs google page rank , the alexa ranking of your site and quite a few others like complete rank , quantcast rank , google yahoo and live search backlinks , social bookmarks and the last one comes from subscribers.
You can even show the popularity of your site by displaying the badge of popuri on your blog or website.This badge gives the complete detailed stats of rankings and backlinks of your site or blog.
I was eager to know who is the first in alexa ranking and it was exactly what i guessed it , the number one on alexa ranking is currently google followed by facebook and so on . Alexa is part of amazon.com and amazon is in 14th rank on alexa .
The link to this site is ( here )
Monday, September 20, 2010
Flag Counter - a Visitor counter with flags of different countries
You have a new blog and you want to make it attractive , then use the flag counter which not only tracks the visitors to your blog but also displays their country flag which makes the blog look more attractive and drives the more traffic to your blog or website. Clicking on this application will take you directly to the statistics section which even the readers can see from your blog.
It shows only the unique visitors for your website or blog , which has two appearance options :
If Flag Map option is used then the following customizations include setting the Maximum number of flags to show and label of the counter you wish to display . The Default label here is Visitors which can be changed to user specific.Apart from this text color and border color can be set easily. If at all you wish to include country codes check " Show Countries Codes ".
Once all the settings are done then finally click the button " GET YOUR FLAG COUNTER " and copy the code and paste it to your blog or website . The alternate options for blogger and other blog sites is to use Quick post options for specific blogs you use.
The link to this site is ( here )
It shows only the unique visitors for your website or blog , which has two appearance options :
- Top Countries - flag representation with unique visitors
- Flag Map - shows world map with flag representing different countries , this is the new addition in features of Flag Counter
If Flag Map option is used then the following customizations include setting the Maximum number of flags to show and label of the counter you wish to display . The Default label here is Visitors which can be changed to user specific.Apart from this text color and border color can be set easily. If at all you wish to include country codes check " Show Countries Codes ".
Once all the settings are done then finally click the button " GET YOUR FLAG COUNTER " and copy the code and paste it to your blog or website . The alternate options for blogger and other blog sites is to use Quick post options for specific blogs you use.
The link to this site is ( here )
Tuesday, September 14, 2010
Cool Template - A Cool text website's new addition
Cool Template is free website template designer or web theme generator with easy to use features and simple user interface with most common features used for any simple websites.It allows you to customize backgrounds, menus , button features ,borders with tranparency and what not you can even select a one column , two column or three column templates for the custom templates designed by you.
( click on the image to expand )
It supports 4 types of templates to be designed , those are
The free version user has to leave the link back to site at footer and comes with ads and paid version has no such restrictions.So why not give a try readers.The link to the website is ( here )
( click on the image to expand )
It supports 4 types of templates to be designed , those are
- HTML template
- Wordpress themes
- Joomla Templates
- Asp.net master pages
The free version user has to leave the link back to site at footer and comes with ads and paid version has no such restrictions.So why not give a try readers.The link to the website is ( here )
Sunday, September 5, 2010
Ping-O-Matic ! - Pinging search engines
Ping-O-Matic is a service that pings your blog to most of the search engines thus avoiding the user to send manual pings separately to each and every search engines.
The site is cool as it pings search engines in seconds. Some of the search engines it pings are weblog,FeedBurner,BlogStreet,BlogRanks,My Yahoo and many more . The user can manually select the search engines to ping or use the " Select All "check box to select all choices for you to submit .
( click on image to expand )
Just enter the Blog Title , Blog Address and Blog feed Url and press "Send Pings " . Thats it , your work is done.Check Out people !!!!
The Link to the site is ( here )
The site is cool as it pings search engines in seconds. Some of the search engines it pings are weblog,FeedBurner,BlogStreet,BlogRanks,My Yahoo and many more . The user can manually select the search engines to ping or use the " Select All "check box to select all choices for you to submit .
( click on image to expand )
Just enter the Blog Title , Blog Address and Blog feed Url and press "Send Pings " . Thats it , your work is done.Check Out people !!!!
The Link to the site is ( here )
Saturday, September 4, 2010
Wibiya Toolbar for Websites and Blogs
Wibiya toolbar is a collest toolbar with most powerful popular social network sharing features like facebook,buzz,twitter and many more with button features on toolbar.It also includes customised items which user can add or delete based on his likes.
It has a tagline of "no coding necessary and add it in 2 minutes".It can be integrated easily without any efforts to blogger,wordpress,joomla,drupal and many more.The most exciting services and web applications into their blog or website can be added.
Another cool feature is the statistics of toolbar which can be tracked easily from their account dedicated for each users through its dashboard feature.The edit toolbar lets you add/remove items from toolbar
Benefits :
It has a tagline of "no coding necessary and add it in 2 minutes".It can be integrated easily without any efforts to blogger,wordpress,joomla,drupal and many more.The most exciting services and web applications into their blog or website can be added.
Another cool feature is the statistics of toolbar which can be tracked easily from their account dedicated for each users through its dashboard feature.The edit toolbar lets you add/remove items from toolbar
Benefits :
- Increase page views
- Increase more and quality traffic to your sites
- Share your posts with most popular social networking sites
- Show latest posts on click of a toolbar
- Communicate with real time readers of your website or blog
- Translator for different languages
- Get the Real time user statistics
- Sharing of images is easier than before
- Show users your Youtube channel videos
Friday, September 3, 2010
Cool Text - Online Graphics Generator
For all those who are looking at generating graphic text or logos then this Cooltext website is very cool and simple as the name suggest.
What is CoolText ?
- Cool Text is a free graphics generator for web pages and you could use it anywhere with ease .
( click on the images to expand )
There are not only designer texts but even you could select a button image and type in your text on button and then anyone could use that button on their websites or blogs . The image of that button will be hosted on the CoolText server.
Applicable for :
Cool Template , an online website designer which is a part of Cooltext website will be reviewed in the coming posts .
What is CoolText ?
- Cool Text is a free graphics generator for web pages and you could use it anywhere with ease .
( click on the images to expand )
There are not only designer texts but even you could select a button image and type in your text on button and then anyone could use that button on their websites or blogs . The image of that button will be hosted on the CoolText server.
Applicable for :
- Text
- Logos
- Buttons
- Fonts
- Download the image directly to pc ( no signup required )
- Embeded the image to website or blog ( signup required )
- Email the image to anyone ( signup required )
Cool Template , an online website designer which is a part of Cooltext website will be reviewed in the coming posts .
Wednesday, September 1, 2010
Automatic Global Translator Mobile Phone
Overview :
There are lots of translators software you come accross , one common addition to this is Google translator(text based) which can translate to any specified language with ease.Assume you dont know Japanese , is it possible for anyone to speak on phone with a person from Japan ?
What if ?
A cell phone which can translate to any language on the go without having to worry much about the unknown languages of the world. We speak english and the phone translates to Japanese , and vice versa , the person speaks Japanese to you,the translator in your phone converts it back to english. How amazing the technology could be if its made functional .
How it works ?
Set the base language of the cell phone, here the base language is the language which we know or which we wish to hear. Just keep on speaking the usual way without any language barrier , the Translator present in cell takes care of it and we could hear the language we want .
Demo Illustration :
1) Mr A tells Hello ( English) to Mr B -> Traslator ( Cell Phone) -> converts to konnichiwa ( Japanese) heard by Mr B .
2) Mr B tells konnichiwa ( japanese) to Mr A - > translator ( Cell Phone) -> converts to Hello ( English) heard by Mr A .
Benefits :
We can talk to any people around the World over phone without the Language barrier . There could be a strong ties between any countries and can be reached to any corner of the world .
There are lots of translators software you come accross , one common addition to this is Google translator(text based) which can translate to any specified language with ease.Assume you dont know Japanese , is it possible for anyone to speak on phone with a person from Japan ?
What if ?
A cell phone which can translate to any language on the go without having to worry much about the unknown languages of the world. We speak english and the phone translates to Japanese , and vice versa , the person speaks Japanese to you,the translator in your phone converts it back to english. How amazing the technology could be if its made functional .
How it works ?
Set the base language of the cell phone, here the base language is the language which we know or which we wish to hear. Just keep on speaking the usual way without any language barrier , the Translator present in cell takes care of it and we could hear the language we want .
Demo Illustration :
1) Mr A tells Hello ( English) to Mr B -> Traslator ( Cell Phone) -> converts to konnichiwa ( Japanese) heard by Mr B .
2) Mr B tells konnichiwa ( japanese) to Mr A - > translator ( Cell Phone) -> converts to Hello ( English) heard by Mr A .
Benefits :
We can talk to any people around the World over phone without the Language barrier . There could be a strong ties between any countries and can be reached to any corner of the world .
" Bringing the World Closer "
Sunday, August 29, 2010
Optical Human Transmitter (OHT) version 1.0
A device which transports human to any desired destination by converting them into photons (light rays) using optical medium such as optical fiber.
A destination point is entered in Optical Human Transmitter where a strong beam of light scans human body and converts atoms into photons and these photons are transmitted through fiber optic links . at the destination end another machine reproduces the actual atoms by photons there by recreating them back to original form
This is one such creative idea i have come across . One say that imagination is the most powerful tool that can reach you any place at any time . Say that you imagine or dream about New York , you reach there in a matter of seconds and travel around those places . How is that possible ? its all about Imagination and its power to take you there .
HUMAN(SOURCE)=>MACHINE=>LIGHT=>OPTIC FIBER=>LIGHT=>MACHINE=>HUMAN(DESTINATION)
FASTEST HUMAN TRANSFER POSSIBLE IN NANO SEC
For those who dream and believe in the power of imagination , why cant this be possible ? Think over it !!!
This was a post for "My Demand Contest" hosted by indiblogger.Hope you enjoyed it .
"Impossible Is Nothing" ...
A destination point is entered in Optical Human Transmitter where a strong beam of light scans human body and converts atoms into photons and these photons are transmitted through fiber optic links . at the destination end another machine reproduces the actual atoms by photons there by recreating them back to original form
This is one such creative idea i have come across . One say that imagination is the most powerful tool that can reach you any place at any time . Say that you imagine or dream about New York , you reach there in a matter of seconds and travel around those places . How is that possible ? its all about Imagination and its power to take you there .
HUMAN(SOURCE)=>MACHINE=>LIGHT=>OPTIC FIBER=>LIGHT=>MACHINE=>HUMAN(DESTINATION)
FASTEST HUMAN TRANSFER POSSIBLE IN NANO SEC
For those who dream and believe in the power of imagination , why cant this be possible ? Think over it !!!
This was a post for "My Demand Contest" hosted by indiblogger.Hope you enjoyed it .
"Impossible Is Nothing" ...
Saturday, August 28, 2010
Optical Human Transmitter
a device which transports human to any desired destination by converting them into photons (light rays) using optical medium such as optical fiber.
a destination point is entered in Optical Human Transmitter where a strong beam of light scans human body and converts atoms into photons and these photons are transmitted through fiber optic links . at the destination end another machine reproduces the actual atoms by photons there by recreating them back to original form
(click on this image to expand)
HUMAN(SOURCE)=>MACHINE=>LIGHT=>OPTIC FIBER=>LIGHT=>MACHINE=>HUMAN(DESTINATION)
FASTEST HUMAN TRANSFER POSSIBLE IN NANO SEC
This is one the craziest ideas , where one can reach any corner one the world from any place. For those who dream and believe in the power of imagination , why cant this be possible ? Think over it !!!
a destination point is entered in Optical Human Transmitter where a strong beam of light scans human body and converts atoms into photons and these photons are transmitted through fiber optic links . at the destination end another machine reproduces the actual atoms by photons there by recreating them back to original form
(click on this image to expand)
HUMAN(SOURCE)=>MACHINE=>LIGHT=>OPTIC FIBER=>LIGHT=>MACHINE=>HUMAN(DESTINATION)
FASTEST HUMAN TRANSFER POSSIBLE IN NANO SEC
This is one the craziest ideas , where one can reach any corner one the world from any place. For those who dream and believe in the power of imagination , why cant this be possible ? Think over it !!!
Friday, August 27, 2010
A presentation on OLED display system
For all those students or technical presenters who are looking out for a technical presentation can have a look at this ppt, Download and get ready to present at seminars. I had presented this ppt for my technical presentation during my engineering college days.At that time this OLED technology was emerging into the markets with the first 11 inch screen developed my Sony Corporation which had costed around 1lakh INR at that time.Now there has been many many screens into the market.
I still remember my college days when i gave this presentation.All the instructors were in their own dreamland.I could see all their faces with full enthusiasm , they must have thought , will this technology ever come into market where one can use their screens folded in their bags ? just like a calendar.
I have embedded the presentation below , which has around 1200 views on dostoc .Hope this would help anyone .
For direct download click ( here )
OLED ( organic light emitting diode)
Few Of the current OLED s in Market :
( Click on the image below to expand )
I still remember my college days when i gave this presentation.All the instructors were in their own dreamland.I could see all their faces with full enthusiasm , they must have thought , will this technology ever come into market where one can use their screens folded in their bags ? just like a calendar.
I have embedded the presentation below , which has around 1200 views on dostoc .Hope this would help anyone .
For direct download click ( here )
OLED ( organic light emitting diode)
Few Of the current OLED s in Market :
( Click on the image below to expand )
Thursday, August 26, 2010
Zoho Viewer - View and Share document online
A common problem - You have power point presentation or a pdf file or xls and you want to share it with the people around the world , In this case you can use Zoho Viewer and upload that file. The files that the viewer supports are Word , Excel , Powerpoint and Adobe( pdf ) . Its a nice viewer where one can
(click on the image to expand)
And the best thing to be noticed here is that , you can specify the expiry time like a day,a week, a month or never expire to the document you have uploaded . Nice Viewer enjoy !!!
The link to the website ( here )
- Embed the document on other websites or blog or share the URL on forums
- Save it on your own system
- Edit the file with lots of features
- Export it in various formats
- View the slideshow online
- Print the document
(click on the image to expand)
And the best thing to be noticed here is that , you can specify the expiry time like a day,a week, a month or never expire to the document you have uploaded . Nice Viewer enjoy !!!
The link to the website ( here )
Air Pad - Easy Transport Concept
Air Pad - easy mode of individual transportation . A pad that almost looks like a roller skater takes the people on its dedicated track to the destination enter by the user on its computer by paying a small amount. A large number of pads on different tracks makes transportation easier , Go Green !
+
=
No Pollution ( full Electric Battery )
Go Green Go World
This is just a creative idea and a go green concept . Just a refresher post . Enjoy !!!!
+
=
No Pollution ( full Electric Battery )
Go Green Go World
This is just a creative idea and a go green concept . Just a refresher post . Enjoy !!!!
Tuesday, August 24, 2010
XML Importer for OA Framework ( A Simple - Easy to Edit Batch File)
As i had mentioned in the previous post about the XML importer . The easy to use and Ready batch file is given below which can be downloaded and a small modification to that file is needed for it to be used. Once this batch file is edited to the page whichever you want to import and just a Double-Click will do the trick to import the (.xml) file to MDS of database. The placing of this batch file will be discussed below .
Usage and Placing of Batch File :
Steps ,
1) Download the import.bat Batch file from the link below -
import.bat
2) Go to jdevbin of jdeveloper extension and look for oaext directory and place the downloaded batch file in bin directory of oaext
ie - jdevbin/oaext/bin/BATCH_FILE_DOWNLOADED
3) Edit the following and leave the rest as it is
right click on import.bat file and click edit , change :
5) Double_Click on batch file
and thats it , simple and cool batch script which can be reused just by changing the XML file.
Your XML file will be imported to the MDS of database and follow my post : (click) to check whether the XML file is imported or not .
Usage and Placing of Batch File :
Steps ,
1) Download the import.bat Batch file from the link below -
import.bat
2) Go to jdevbin of jdeveloper extension and look for oaext directory and place the downloaded batch file in bin directory of oaext
ie - jdevbin/oaext/bin/BATCH_FILE_DOWNLOADED
3) Edit the following and leave the rest as it is
right click on import.bat file and click edit , change :
- JDEV_BIN_HOME to your jdev_bin_home
- JDEV_USER_HOME to your jdev_user_home
- In DB_CONNECTION change host , port ( if applicable ) and SID
- PAGE2UPLOAD path of the (.xml ) file to import
- APPS_PASSWD your password
5) Double_Click on batch file
and thats it , simple and cool batch script which can be reused just by changing the XML file.
Your XML file will be imported to the MDS of database and follow my post : (click) to check whether the XML file is imported or not .
A note on all the $TOP directory of Oracle apps R12
The $TOP is the top most directory or can be said as an important directory for all oracle apps R12 .In order to use these directories through "cd" command of linux, we must the source the Environment variables .The two important Environment variables for a developer would be :
- Its located at $APPL_TOP ie at " d01/oracle/[SID]/apps/apps_st/appl " .
How do you source the Environment variables ?
- sourcing is done by using a dot (.) followed by and then environment variable name
example : To source VIS_localhost.env :
Note : don't forget to leave a space between dot (.) and env file .
A list of $TOP directories and their paths :
1) $APPL_TOP - d01/oracle/[SID]/apps/apps_st/appl/
2) $JAVA_TOP - d01/oracle/[SID]/apps/apps_st/comn/java/classes/
3) $(application_short_name)_TOP - d01/oracle/[SID]/apps/apps_st/appl/(application_short_name)/12.0.0
example : for application_short_name PER - ( human resource)
$PER_TOP - d01/oracle/[SID]/apps/apps_st/appl/per/12.0.0
Last thing to mention is about , $ORACLE_HOME ,
4) $ORACLE_HOME - d01/oracle/[SID]/apps/tech_st/10.1.2
Note : SID and HostName varies from system to system
[sid]_[HostName] .env - APPS
[SID]_(HostName).env
- Its located at $APPL_TOP ie at " d01/oracle/
How do you source the Environment variables ?
- sourcing is done by using a dot (.) followed by
example : To source VIS_localhost.env :
. VIS_localhost.env |
Note : don't forget to leave a space between dot (.) and env file .
A list of $TOP directories and their paths :
1) $APPL_TOP - d01/oracle/
2) $JAVA_TOP - d01/oracle/
3) $(application_short_name)_TOP - d01/oracle/
example : for application_short_name PER - ( human resource)
$PER_TOP - d01/oracle/
Sunday, August 22, 2010
A note on jdr_utils API s of OA Framework
Jdr_utils package is most important APIs commonly used in OA Framework customisation. The most import scripts used are as follows :
1) The script which lists all the MDS documents of specified directory currently imported into database :
DECLARE
BEGIN
jdr_utils.listdocuments ( '/oracle/apps/per/selfservice.webui' , TRUE ) ;
END ;
2) The script to list the Personalizations or Extensions for a specific object :
DECLARE
BEGIN
jdr_utils.printdocument ( ' p_document => /oracle/apps/per/selfservice.webui/ somepagePG ') ;
END ;
3) The script to delete document or personalizations/extensions :
DECLARE
BEGIN
jdr_utils.deletedocument ( ' p_document => /oracle/apps/per/selfservice.webui/ somepagePG ') ;
END ;
- JDR_UTILS.LISTDOCUMENTS
- JDR_UTILS.PRINTDOCUMENT
- JDR_UTILS.DELETEDOCUMENT
1) The script which lists all the MDS documents of specified directory currently imported into database :
DECLARE
BEGIN
jdr_utils.listdocuments ( '/oracle/apps/per/selfservice.webui' , TRUE ) ;
END ;
2) The script to list the Personalizations or Extensions for a specific object :
DECLARE
BEGIN
jdr_utils.printdocument ( ' p_document => /oracle/apps/per/selfservice.webui/ somepagePG ') ;
END ;
3) The script to delete document or personalizations/extensions :
DECLARE
BEGIN
jdr_utils.deletedocument ( ' p_document => /oracle/apps/per/selfservice.webui/ somepagePG ') ;
END ;
Saturday, August 21, 2010
Checking the presence of ( . xml) file in MDS of Oracle (OA Framework)
Whenever there is a new page added or any customization done to Oracle apps applications we use XML importer to import the new custom XML page to MDS of database.The XML importer Batch script to import XML files into MDS is ( here )
Assuming that you have imported the XML file ,and when you run the application the most common error would be (see the screen Shot)
The first thing to check here is whether you have successfully imported the XML page or not.To check this :
Run : On Sql * Plus or SqlDeveloper ,
DECLARE
BEGIN
jdr_utils.printdocument ( p_document => ' /oracle/apps/per/selfservice/appraisals/somePG' )
END ;
The parameter to p_document is your XML path you wish to check . Few of the jdr_utils package will be discussed in coming posts.
Assuming that you have imported the XML file ,and when you run the application the most common error would be (see the screen Shot)
( click the image to expand )
The first thing to check here is whether you have successfully imported the XML page or not.To check this :
Run : On Sql * Plus or SqlDeveloper ,
DECLARE
BEGIN
jdr_utils.printdocument ( p_document => ' /oracle/apps/per/selfservice/appraisals/somePG' )
END ;
The parameter to p_document is your XML path you wish to check . Few of the jdr_utils package will be discussed in coming posts.
Thursday, August 19, 2010
Command to print the Current Working Directory
The most commonly used command to print the current working directory .This command prints the full filename of the current working directory.
Example :
Example :
pwd |
Monday, August 16, 2010
Bounce Apache for Oracle R12 applications (Linux RHEL 5 )
Any changes made to R12 applications through Jdeveloper or professional interface such as forms interface has to be bounced . One easiest way to bounce apache is to use adapcctl script located at scripts directory of INSTANCE_TOP.
Root user and Applmgr user can run this script , for R12 the instance top directory is located at /d01/oracle//inst/apps/_/ i.e $INST_TOP
Bounce the Apache server :
Locate the scripts directory at $INST_TOP/admin/scripts
then ,
then,
Note : Root user and Applmgr user can run this script
Root user and Applmgr user can run this script , for R12 the instance top directory is located at /d01/oracle/
Bounce the Apache server :
Locate the scripts directory at $INST_TOP/admin/scripts
then ,
./adapcctl.sh stopall |
then,
./adapcctl.sh startall |
Note : Root user and Applmgr user can run this script
Tuesday, August 10, 2010
Google Translate Widget
If you want your readers to read the blog or website of yours into different languages , then here s the coolest widget for you all , that is Google Translate.One of the best gadget that translates your webpage or blogger page into different languages selected by the user that reads your blog.website .
For working example check the right right hand top corner of my blog:
Is'nt it cool , then try out and increase your website or blog traffic. Solution for using this is simple . Click Here to visit the website and do the following :
For working example check the right right hand top corner of my blog:
Is'nt it cool , then try out and increase your website or blog traffic. Solution for using this is simple . Click Here to visit the website and do the following :
- Select the language of your web page , that is base language
- Choose the optional setting either all languages or specify the languages which you want to make your readers read
- Copy and paste it where ever you want in your blog or website .
Monday, August 9, 2010
Command to Change owner and group of file or directory
The Command used to change owner and group of file or directory uses the following :
Change the owner name of the file :
Change the owner name of the file :
Change the owner name and group name of the file :
Change the owner name and group name of the directory :
Example :
If you want to change the group name as : dba and owner name as user1 for the directory name MyDirectory then the command :
To recursively change the owner of the files or folders of directory :
use -R ,
Using –v along with –R will list the changes made ,
Change the owner name of the file :
chown UserName FileName |
Change the owner name of the file :
chown username DirectoryName |
Change the owner name and group name of the file :
chown UserName:GroupName FileName |
Change the owner name and group name of the directory :
chown UserName:GroupName DirectoryName |
Example :
If you want to change the group name as : dba and owner name as user1 for the directory name MyDirectory then the command :
chown user1:dba MyDirectoryName |
To recursively change the owner of the files or folders of directory :
use -R ,
chown -R owner File/Folder |
Using –v along with –R will list the changes made ,
chown -Rv owner Folder |
Find command to search for files and folders
Find command is used to find or search for a particular files or folder or prints out contents of entire folder or look for files or folders containing then names which you pass along with command. Its usage are as follows :
Looks for all the files and folders of current directory :
Files or folders containing particular name :
Example :
To find all files with (.dbc) extension :
Looks for all the files and folders of current directory :
find . |
note : find is followed by a dot (.) , here dot represents the current directory .
Files or folders containing particular name :
find -name -print FileName/ FolderName/ FileName(s) |
Example :
To find all files with (.dbc) extension :
find -name -print *.dbc |
Note : (*) is a wildcard character which displays all files with a particular name or extension.
Tuesday, August 3, 2010
Online image editor - Pixlr
This image editor doesn't require you to install the software on your PC,its very simple and useful tool when it comes to online image editing .Its almost like a pocket image editor whose features are almost close to photoshop that is used everywhere.
Pixlr is online free editor where anyone can create a new image from scratch ,i.e a blank page where one can set the height and witdth of page and ready to use the tools.
Other feature include , opening a existing image from your computer and editing it , users can get any image from the internet by specifying the URL of that image and its ready to be edited with useful and cool tools of Pixlr.Once editing is done ,use File - > save or use ctrl + s
Here s your online editor : Pixlr
Pixlr is online free editor where anyone can create a new image from scratch ,i.e a blank page where one can set the height and witdth of page and ready to use the tools.
Other feature include , opening a existing image from your computer and editing it , users can get any image from the internet by specifying the URL of that image and its ready to be edited with useful and cool tools of Pixlr.Once editing is done ,use File - > save or use ctrl + s
Here s your online editor : Pixlr
Sunday, August 1, 2010
Free Studio for multipurpose solutions
Free Studio is a single package which combines all free software from DVDVideoSoft to work with DVD, video and audio files.There are single and separate softwares you need to download from their website. One my my posts was about converting video to mp3 online , This post can assume the same but more powerful features both offline and online .
One installation of this software gives you the power to use more than 20 odd programs with each of them need to be downloaded separately.Few of them are : (For seperate programs use the following links)
For Downloading the Free studio visit the DVDsoft website from here
One installation of this software gives you the power to use more than 20 odd programs with each of them need to be downloaded separately.Few of them are : (For seperate programs use the following links)
- YouTube Download
- YouTube to MP3 Converter
- YouTube to iPod and PSP Converter
- YouTube to iPhone Converter
- YouTube to DVD Converter
- YouTube Uploader
- DVD Video Converter
- Video to DVD Converter
- Video to Flash Converter
- 3GP Video converter
- Video to iPod and PSP Converter
- Video to iPhone Converter
- Video to MP3 Converter
- Video to JPG Converter
- Audio Converter
- Audio to Flash Converter
For Downloading the Free studio visit the DVDsoft website from here
Screen Capture Tool aka Print Screen
As you all are familiar with the print screen button on a standard keyboard,if not in a simple words its used to capture the entire screen on pc. The screen is captured in buffer and to use that captured screen we use microsoft paint and just pressing "ctrl+v" on a new page one can see the captured screen.
The above steps is nothing but a traditional way of using print screen feature. There is one powerful and small software with more features that can accomplish all the print screen related activities.Indeed, the screen capture is a important tool.The LS screen capture by Linos software gives the answer to all print screen solutions .
LS Screen Capture, this small application proforms a small but needed function. It captures your desktop in several handy ways.
For System requirements and download click here
The above steps is nothing but a traditional way of using print screen feature. There is one powerful and small software with more features that can accomplish all the print screen related activities.Indeed, the screen capture is a important tool.The LS screen capture by Linos software gives the answer to all print screen solutions .
LS Screen Capture, this small application proforms a small but needed function. It captures your desktop in several handy ways.
- Capture the entire desktop screen
- Capture the entire desktop work area
- Capture using your mouse by creating a rectangle
- Capture an entire window
- Capture the entire window work area
- Capture any active window with key stroke (Ctrl + F2)
For System requirements and download click here
Wednesday, July 28, 2010
Video To Mp3 (online)
You have come across situation where you are watching a video and you intend to download the mp3 of that video.Here is the simple solution .The website for taking out the mp3 from video is video2mp3 . Take note of url of that video or copy that link from your address bar and paste it in the area named Video URL. The screenshot from the website :
Choose from either standard quality or high quality and click convert. It takes few minutes . Wait for 20 seconds or click on their Download Mp3 link.
For formats other than Mp3 like AAC/WMA/M4A/OGG/MP4/3GP/AVI/MPG/WMV/FLV use their other website ClipConverter
Choose from either standard quality or high quality and click convert. It takes few minutes . Wait for 20 seconds or click on their Download Mp3 link.
For formats other than Mp3 like AAC/WMA/M4A/OGG/MP4/3GP/AVI/MPG/WMV/FLV use their other website ClipConverter
Saturday, July 24, 2010
Remove Directory command
Removes directory when contents inside it are empty :
Delete all the contents including contents of sub-directory with out the prompt message,in simple recursive delete without prompt :
recursive delete with prompt messages :
  rmdir directory_name |
Delete all the contents including contents of sub-directory with out the prompt message,in simple recursive delete without prompt :
  rm -rf directory_name |
recursive delete with prompt messages :
  rm -r directory_name |
Using Unzip command to unzip files
Preserving directory and sub-directory :
Include all junk path names without preserving directory structure :
Specify the name of the directory where you want to unzip :
  unzip file_name.zip |
Include all junk path names without preserving directory structure :
  unzip -j file_name.zip |
Specify the name of the directory where you want to unzip :
  unzip file_name.zip -d directory_name |
Checking Disk space
The command used to check disk space :
df stands for " disk file system " using -h along with df shows the disk space in human readable form .
  df |
df stands for " disk file system " using -h along with df shows the disk space in human readable form .
  df -h |
Uncompress and open tar.gz files
To Uncompress the tar.gz file the command used :
The resulting file would be Name_of_file.tar .To open that tar file the commnand used:
  gunzip -d Name_of_file.tar.gz |
The resulting file would be Name_of_file.tar .To open that tar file the commnand used:
  tar -xvf Name_of_file.tar |
Thursday, July 22, 2010
RPM - RPM package manager
Here are the few commands relating to rpm package from installing to deleting and few others . The commands are :
1) Installing rpm package :
2) To check installed rpm packages :
3) To delete the installed rpm packages :
Note : here (.rpm ) is not used while deleting packages
1) Installing rpm package :
- single package
rpm -i PackageName.rpm |
- multiple package
rpm -i PackageName1.rpm PackageName2.rpm ... .rpm |
2) To check installed rpm packages :
rpm -qa PackageName* |
Note : here * is a wildcard character which displays all names ,it does pattern matching.
3) To delete the installed rpm packages :
rpm -e PackageName |
Note : here (.rpm ) is not used while deleting packages
Enabling port 8000 or 80 on Linux
A very simple method to check whether the port is working or not is , type the following at console :
telnet your_ip port_number (which u want to check)
if you are able to connect it or can see a blank screen means the port is "open".
if not then change the firewall settings , do the following :
-A RH-Firewall-1-INPUT -m state NEW -m tcp --dport 21 -j ACCEPT
-A RH-Firewall-1-INPUT -m state NEW -m tcp --dport 22 -j ACCEPT
See if there is --dport 80 or 8000 or anyport which you want to access , if not add the following entry to iptables changing the --dbport to whichever port you want to open.
hope this works , !!!!!!!
telnet your_ip port_number (which u want to check)
telnet 192.168.1.2 8000 |
if you are able to connect it or can see a blank screen means the port is "open".
if not then change the firewall settings , do the following :
- check the : vi /etc/sysconfig/iptables
-A RH-Firewall-1-INPUT -m state NEW -m tcp --dport 21 -j ACCEPT
-A RH-Firewall-1-INPUT -m state NEW -m tcp --dport 22 -j ACCEPT
See if there is --dport 80 or 8000 or anyport which you want to access , if not add the following entry to iptables changing the --dbport to whichever port you want to open.
-A RH-Firewall-1-INPUT -m state NEW -m tcp --dport 80 -j ACCEPT |
service iptables restart |
hope this works , !!!!!!!
Subscribe to:
Posts (Atom)