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

153 total views, no views today

» Read more

How to connect to CPanel Remote MySql in Java ?

How to connect to CPanel Remote MySql in Java ? When you are having your code in local and you want to connect your remote mysql which is in your cpanel, then you need to follow below steps to connect to it.   Step 1: Login to CPanel and Navigate to Remote MySql   Login to cpanel and navigate to

117 total views, no views today

» Read more

MongoDB CRUD Commands for Beginners

If you are very new to MongoDB and do not have MongoDB installed in your machine, refer the below link to install mongodb on windows 7.   How to install mongodb on windows 7 ?   This is how data stores in MongoDB, Database -> collections -> Documents (structured and unstructured)   Where In RDBMS, Schema -> Database -> Tables

82 total views, 1 views today

» Read more

How to connect MongoDB with Java ?

how to connect mongodb with java ?

How to connect MongoDB with Java ?: MongoDB is a document based open source data model. It stores the unstructured data’s in a JSON format. In our earlier posts we have seen how to install mongodb on windows 7 and resolved some of the most common issues while installing mongodb in windows 7.   How to install mongodb on windows

81 total views, no views today

» Read more

How to install mongodb on windows 7 ?

how to install mongodb on windows 7

How to install mongodb on windows 7 ? Step 1: Download the MongoDB for windows 7   Download MongoDB windows binary files from here, For windows 7, Mongodb for windows 7 [Download the zip version not msi] For windows 2008+ (for windows 10 as well) Mongodb for Windows 2008+ or windows 10 (Size is around 232MB)   Step 2: Extract

184 total views, 1 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

54 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” />

151 total views, no 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!

73 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

71 total views, no views today

» Read more

count of max in mysql example query

Count: Count is an aggregate function which returns the count of rows with respect to our query conditions. Max: Max is an aggregate function which returns the max of rows value of a particular column with respect to our query condition. For string which returns the maximum length value instead of occurences. So you have to use count of max

67 total views, no views today

» Read more
1 2 3