This tutorial is about creating connection to Microsoft SQL Server 2008 using third party jdbc driver in Oracle SQL Developer and exporting database from SQL Server to Oracle database using export to oracle features in Oracle SQL Developer. Source to download third party jdbc driver : https://sourceforge.net/projects/jtds/?source=typ_redirect
Views: 13724 Subhroneel Ganguly
Crystal report is a business intelligence software made for reporting specifically for business analysis. Here is a demonstration to connect the most crystal report to SQL Server and calling reports from VB application. A Visual Basic tutorial along with Crystal report tutorial about creating connection string to dynamically calling crystal report. I have shared the source code but it does not contains the crystal report, and make your own connection string before running. https://drive.google.com/file/d/0BznrW3lgX0ozZHkxY1h2TFlfRlE/view?usp=sharing
Views: 11694 Subhroneel Ganguly
Views: 21425 Subhroneel Ganguly
Database link are used to connect to database which is on different host and different instance, where you cannot use schema.table_name. But it gives you the freedom to manipulate the remote database table as if they are located in you own schema. This is the first part of database link video, on next videos will show you how database link can be used in datawarehousing.
Views: 8031 Subhroneel Ganguly
This asp.net tutorial consists of to projects one for creating asp.net web service and another is how to invoke that web service from C# desktop application. Web service is created using soap service and SQL Server database is used to retrieve data with the web service. Project: Source Code : https://drive.google.com/file/d/0BznrW3lgX0ozcnlBMzdGS01uclU/view?usp=sharing
Views: 59457 Subhroneel Ganguly
This tutorial is about oracle forms parameter passing while calling it from another form. How to pass parameters from one form to another form in Oracle forms, passing and manipulating parameters dynamically from one form to another.
Views: 11370 Subhroneel Ganguly
This tutorial is about creating database linked server in Microsoft SQL Server 2014 to connect to Oracle Database XE. You require to install Oracle instant client and configure net service name to use as data source. Example of executing dml script is mentioned in this video.
Views: 18662 Subhroneel Ganguly
This tutorial is about installing Oracle Weblogic Server 11g Release 1 on Windows Machine. This oracle tutorial is not an advanced one, but shown simple steps to install Weblogic server and it's component, like coherence, weblogic tools, and configuring Administration Server, Managed Server, Node Manager, Machines, linking machines to managed servers.
Views: 43199 Subhroneel Ganguly
This training video shows how to call Oracle Reports run-time from Oracle Forms 6i using runproduct functions.
Views: 26476 Subhroneel Ganguly
Using SQL Developer to connect to MySql database using jdbc driver jar file. Although it does not provide full fledged privilege but you can write query, insert, update, delete, browse objects and many more. All you need to do is download mysqlconnector jar file from oracle download repository.
Views: 8410 Subhroneel Ganguly
How to Connect To Oracle 11g DataBase Using JSP and Apache Tomcat Server 6.0. This is an online training video oracle tutorial to connect to Oracle database using JSP and Apache tomcat application server. Also learn sql to retrieve data and populate into jsp page. ojdbc5.jar file link : http://www.java2s.com/Code/JarDownload/ojdbc5/ojdbc5.jar.zip Extract zip file ad copy it to $CATALINA_HOME/LIB directory. Code for dbconnection.jsp is added i comment section.
Views: 26032 Subhroneel Ganguly
AngularJS is a single page application framework which make programming fast and effective. This program uses $http get in angularjs to retrieve data from an external json file created by jsp page using apache tomcat 7.0 web server and oracle 12c database server. It also includes searching technique which filters data within your search criteria. For Oracle JSP, platform used : Apache Tomcat 7.0, Oracle 12c release 1 database and Java jdk 1.6, ojdbc6.jar file located at CATALINA_HOME\lib\ folder. HTML Source Code : https://drive.google.com/file/d/0BznrW3lgX0ozdk5qY2JGcXRtYjg/view?usp=sharing JSP Oracle source code : https://drive.google.com/file/d/0BznrW3lgX0ozdFpnaG55c1BVbU0/view?usp=sharing
Views: 10084 Subhroneel Ganguly
How To Start Or Stop Oracle Service In Red Hat Linux Enterprise 6.0.
Views: 14125 Subhroneel Ganguly
A visual basic lesson about how to write propbag.readproperties and propbag.writeproperties. This visual basic demonstrate adding usercontrol in vb project, writing get and let properties and setting read and write properties using propbag. Usercontrol Source Code : https://drive.google.com/file/d/0BznrW3lgX0ozazRmR2NUVXlPNUk/view?usp=sharing
Views: 3053 Subhroneel Ganguly
This tutorial is about connecting to DB2 database using Oracle SQL Developer client and third party jdbc driver. SQL Developer will not only help you to connect to DB2 database engine but also help you perform DDL and DML operation like create / alter / drop table. Select, insert, Update and Delete. Please find the third party jdbc driver : https://drive.google.com/open?id=0BznrW3lgX0ozRUxmcU0zbmVVZms
Views: 15057 Subhroneel Ganguly
How to start, stop or restart Network Service in Red Hat Enterprise Linux 6.0.
Views: 3175 Subhroneel Ganguly
How to connect to Oracle Database using Toad for Oracle. Online Video to learn the simple way to connect to database through Toad for Oracle. Learn Oracle connectivity from configuring tnsnames.ora , net8 client configuration to connecting to toad. A complete oracle tutorial.
Views: 124035 Subhroneel Ganguly
How to write post query trigger in Oracle Forms. Post query triggers at block level to retrieve data from other table. This is a small tutorial in Oracle forms to show you creating forms post query trigger, writing pl sql code into triggers.
Views: 8809 Subhroneel Ganguly
This oracle tutorial has a basic information to create a scheduled job in Oracle database 12c. Along with viewing properties of the scheduler and monitoring schduler.
Views: 9948 Subhroneel Ganguly
How to enable SSL port for Apache Tomcat Server 7.0. Also see how to install SSL certificate using java keytool utility. When you install Tomcat in Windows / Linux machine by default you https port is disabled and you need to enable it if you want to run your web server through https. This tutorial show you how to enable the port, you can also get clear about port conflict occurs if multiple web server is installed and how to solve it.
Views: 19355 Subhroneel Ganguly
This video tutorial is about creating a data model on existing schema using Oracle SQL Developer. This tutorial also includes adding referential constraints with data model and generating DDL from the data model.
Views: 11578 Subhroneel Ganguly
In this tutorial I have listed some methods that can be used in PL SQL collection like type table. This methods enables you to use your collection in a more flexible way. I have just skipped the limit method as I am only stuck with table type collection other than that all methods are properly explained.
Views: 7599 Subhroneel Ganguly
This tutorial is about sending message from client to server using UDP connection-less protocol. This video tutorial includes 2 program. 1. socket_server_udp.py 2. socket_client_udp.py. Server binds to an ip address with a random port waits to receive message from client using an infinite loop. Client send messages to server which is received by server and prints it.
Views: 2439 Subhroneel Ganguly
How to install Oracle 11g Release 2 and configure in Windows 64 bit. Oracle database tutorial with simplest steps to install Oracle 11g on Windows OS with Net configuration and database configuration guidelines.
Views: 213771 Subhroneel Ganguly
Dates in Oracle PL SQL is definitely the most powerful among all other databases. It gives us full flexibility to manipulate it of our choice, whether you are calculating days, months or year, printing date and time in various format. Useful date functions add_months, months_between, last_day, next_day and to_char helps us a lot in handling date time in our pl sql programming.
Views: 5965 Subhroneel Ganguly
How to dynamically generate csv report from database table using sql query. An Online Training video which demonstrate with code to export data from database into CSV file.
Views: 2907 Subhroneel Ganguly
Oracle 12c database connectivity with forms 6i. How to resolve No matching authentication protocol issue in Oracle Forms 6i connectivity. Oracle forms 6i connectivity issue with Oracle 12c database solved easily by a single line of statement in sqlnet.ora file on server side.
Views: 9774 Subhroneel Ganguly
In a previous video I have shown how to retrieve data from Oracle and render page with AngularJS, in this tutorial we discussed about adding, updating and deleting oracle data from web page using AngularJS. It's dynamic, it's fast. Providing the source code consisting of 3 files. 1. test.html, 2. insertUpdateDelete.jsp and 3. get_oracle_data.jsp https://drive.google.com/file/d/0BznrW3lgX0ozMi1XMHY3NHIyUk0/view?usp=sharing
Views: 12737 Subhroneel Ganguly
How to connect to Oracle 11g release 2 from Crystal Report 11 release 2. This tutorial demonstrate crystal reports 11 oracle connection using OLEDB (ADO) driver.
Views: 13003 Subhroneel Ganguly
AngularJS is a single page application framework which make programming fast and effective. This program uses $http get in angularjs to retrieve data from an external json file. It also includes searching technique which filters data within your search criteria. Source Code link : http://embed.plnkr.co/bnumW0RmvE3Izt7UeePZ/index.html
Views: 52753 Subhroneel Ganguly
How to design and build Menu in Oracle Forms. Designing and building menu in Oracle Form and attaching in forms in design time. This is an Online Training oracle tutorial video to make viewer to be able to build menu in a simple manner.
Views: 27663 Subhroneel Ganguly
Views: 1993 Subhroneel Ganguly
Online Training video to guide you how to select top N records using nested query in pl / sql.
Views: 2787 Subhroneel Ganguly
Configure Jasper Report Server, uploading jrxml reports developed in Jasper Studio, configuring data source for oracle database connection.
Views: 2296 Subhroneel Ganguly
Building Matrix with Group Report using Oracle Report Builder 6.0 and Oracle Database 11g database.
Views: 5343 Subhroneel Ganguly
How to use Format Trigger In Oracle Report Builder 6i to filter record in Report Layout
Views: 18250 Subhroneel Ganguly
This struts video tutorial is a continuation of the previous tutorial "Create your first struts application". This video shows how to create a login action class to invoke success or failure page on providing correct or wrong user information. The project consists of 1. login.jsp 2. MainPage.jsp 3. login.java 4. struts.xml New package added to struts.xml for login action. I am providing the source code link : https://drive.google.com/file/d/0BznrW3lgX0ozT29TSk5VU2l5UWM/view?usp=sharing
Views: 2726 Subhroneel Ganguly
This tutorial contains two utilities. 1. Finding your current location 2. Searching a particular location. Markers are also added with hard-coded array elements containing name of cities and it's coordinates. Filters are also applied to convert decimal coordinated to degree minutes and seconds. I hope you find this angularjs tutorial helpful. Source Code : https://drive.google.com/file/d/0BznrW3lgX0ozTnh3NFMxY3ZydEU/view?usp=sharing
Views: 11066 Subhroneel Ganguly
Learn how to send email using smtp and python in a few easy steps. Gmail smtp.googlemail.com server is being used to send email. We have used smtplib, email.mime.multipart and email.mime.text library for connecting to server, building email structure and attaching message text respectively. Here is the code link to download the code : https://drive.google.com/file/d/0BznrW3lgX0ozeHhGMXBrcGNCdW8/view?usp=sharing
Views: 6905 Subhroneel Ganguly
This is a small and basic AngularJS project to implement google map with angular js. In this project I have used 3 files. 1. google-maps.html 2. map.js 3. map.css I have used country India and some renowned cities. You can see the information wither by clicking into the balloon or also click on the buttons below to fire the click event listener. Source Code Link : https://drive.google.com/file/d/0BznrW3lgX0ozWk94UW5QcGpDbHc/view?usp=sharing
Views: 14029 Subhroneel Ganguly
Views: 1243 Subhroneel Ganguly
Merge Statement in PLSQL not only optimize you code, it also make you code looks good and readable, save you from using a long and redundant code like using cursor loop, plsql collection object, all done with a few line of statement.
Views: 1163 Subhroneel Ganguly
A plsql tutorial about how to reference old and new column value of a table using :old or :new and how they are related to insert, update or delete dml transaction. Go through this oracle tutorial which will give you the concept about how to use :old and :new references. Here is the trigger example. create or replace trigger trigger_name before insert or update or delete on table_name for each row begin if inserting then dbms_output.put_line("Before inserting Old value is "||:old.column_name||" New value : "||:new.column_name); elsif updating then dbms_output.put_line("Before updating Old value is "||:old.column_name||" New value : "||:new.column_name); elsif deleting then dbms_output.put_line("Before deleting Old value is "||:old.column_name||" New value : "||:new.column_name); end if; end;
Views: 4245 Subhroneel Ganguly
How to export CSV data from Oracle database 12c using PHP. If you need to about Oracle connectivity with PHP go through this video : https://www.youtube.com/watch?v=IJ10-XCR4H4 Source Code Link : https://drive.google.com/file/d/0BznrW3lgX0ozaTFTeDJEWWd6VE0/view?usp=sharing
Views: 1509 Subhroneel Ganguly