Oracle PL/SQL Quick Notes

Hi Guys, We come across few queries in oracle and pl/sql on daily development tasks which we forget/wont remember correctly sometime. This post keeps track on those items. Keep visiting this post for the regular updates.   This can be used to refresh for your oracle and pl/sql interviews as well. Feel free to add your thoughts in the comments

0 total views, 0 views today

» Read more

How to Insert Single and Double Quotes in Oracle?

How to Insert Single and Double Quotes in Oracle? Inserting Single quote in oracle: If your query is like this, insert into emp (id,name,salary) values (10,’Naveen’s’,10000); // error then you will get the error for the single quote in the name. We have to escape it to insert in oracle using one more single quote like this, insert into emp

114 total views, no views today

» Read more

Autocomplete using jQuery, PHP and MySQL

autocomplete_output

Autocomplete is a basic mandatory functionality in any web development. It will help user to find the correct item just with partial name/some letters of the item which they know about the item.     Import the below scripts and CSS’s: <script type=”text/javascript” src=”http://code.jquery.com/jquery-2.1.1.min.js”></script> <script type=”text/javascript” src=”//maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js”></script> <script type=”text/javascript” src=”http://ajax.aspnetcdn.com/ajax/jquery.ui/1.11.0/jquery-ui.min.js”></script> <link rel=”stylesheet” href=”http://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/themes/redmond/jquery-ui.css” type=”text/css” /> <link rel=”stylesheet” href=”//maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css” type=”text/css” />

252 total views, 1 views today

» Read more

Java With MySQL Select Example

Download the users_test table: Users_test table – Mysql download Loading the Mysql connection: public Connection LoadDriver() { Connection connection = null; try { // Driver Name String mySQLDriver = "org.gjt.mm.mysql.Driver"; // Path/database name [here guru is the database name] String url = "jdbc:mysql://localhost:3306/guru"; Class.forName(mySQLDriver); // User name and password connection = DriverManager.getConnection(url, "root", "pass123"); } catch (Exception exception) { System.err.println("Exception!

118 total views, no views today

» Read more

select with timestamp or date in oracle

select with timestamp or date in oracle: If you want to select the date field or timestamp field with the given date, then you have to use the query like this, select * from TABLE_NAME where TO_CHAR(TIMESTAMP_OR_DATE_COLUMN,’DD-MM-YYYY’) =’25-02-2014′; Eg: select * from POST_SITE where TO_CHAR(POST_TMS,’DD-MM-YYYY’) =’25-02-2014′; here POST_SITE is the name of the table and POST_TMS is the name of

116 total views, 1 views today

» Read more
1 2 3