Videos uploaded by user “Subhroneel Ganguly”
Migrate SQL Server Database to Oracle using SQL Developer
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: 13727 Subhroneel Ganguly
Connect Crystal Report to SQL Server and call from VB6.
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: 11697 Subhroneel Ganguly
Add or remove data in html table using AngularJS
This angularjs tutorial is about creating a dynamic html table using angularjs and javascript array functions. Adding data to an array and removing data from the array and populating data into html table. This type of program is very useful working with list based data. Source Code link : https://drive.google.com/file/d/0BznrW3lgX0ozUTJSamFVMWZDYUE/view?usp=sharing
Views: 21426 Subhroneel Ganguly
How to create and use database link in Oracle
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: 8035 Subhroneel Ganguly
Creating Jasper report from Oracle data source.
Creating a jasper report using Oracle database source. A basic tutorial to learn to create data adapter, using data adapter in jasper report. Designing jasper report using source table writing custom queries.
Views: 6381 Subhroneel Ganguly
Create web service in visual studio 2010 to retrieve data from SQL Server.
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: 59460 Subhroneel Ganguly
How to pass parameters from one form to another in Oracle forms.
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: 11371 Subhroneel Ganguly
Configuring Linked Server in SQL Server to connect to Oracle database
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: 18665 Subhroneel Ganguly
Install and Configure Oracle Weblogic Server on Windows.
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: 43204 Subhroneel Ganguly
How to call Oracle Reports run-time from Oracle Forms using Runproduct.
This training video shows how to call Oracle Reports run-time from Oracle Forms 6i using runproduct functions.
Views: 26478 Subhroneel Ganguly
Connect to Mysql db from Oracle Sql Developer
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: 8411 Subhroneel Ganguly
How to Connect To Oracle 11g Database Using JSP.
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
Retrieve data from Oracle database using ajax and angularjs
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 Database Service In Red Hat Linux Enterprise 6.0.
How To Start Or Stop Oracle Service In Red Hat Linux Enterprise 6.0.
Views: 14126 Subhroneel Ganguly
How to create custom properties in Visual Basic 6 Usercontrol.
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
Connecting to DB2 database using SQL Developer and jdbc driver.
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: 15066 Subhroneel Ganguly
How to start, stop or restart Network Service in Red Hat Enterprise Linux 6.0.
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.
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: 124043 Subhroneel Ganguly
How to write post query trigger in Oracle Forms.
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
How to create and monitor scheduled jobs in Oracle
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: 9950 Subhroneel Ganguly
How to add User Parameters in Oracle Reports.
This is a online training video on adding user parameters in Oracle Reports. Parameter configuration, calling reports from Oracle forms with parameter list.
Views: 11260 Subhroneel Ganguly
How to enable SSL port for Apache Tomcat Server.
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
Creating data model with Oracle SQL Developer  - Part 1
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: 11585 Subhroneel Ganguly
Collection methods in PLSQL Oracle.
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
Using connectionless UDP protocol to send message using Python.
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 and configure Oracle 11g Release 2 in Windows 64 bit
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: 213773 Subhroneel Ganguly
Working with dates in Oracle PLSQL.
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 Create CSV from a database table using ADODB in VB6.
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
How to connect to Oracle database 12c from Developer 2000, Forms and Reports
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: 9777 Subhroneel Ganguly
Add, Update, Delete Oracle data with AngularJS and JSP
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: 12738 Subhroneel Ganguly
How to connect to Oracle 11g database from Crystal Report 11 release 2.
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: 13004 Subhroneel Ganguly
Using ajax $http.get in angularjs to retreive file JSON data
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 Form Builder
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
Adding shapes and markers in Google Map.
This tutorial is in javascript using googlemap api. In this tutorial we add three city markers and connect them with polyline showing flight path and also drawn circle around one city on respective coordinates. Source Code link: https://drive.google.com/file/d/0BznrW3lgX0ozS2hnUXEyMFR0UGs/view?usp=sharing
Views: 1993 Subhroneel Ganguly
Difference between gzip and tar command in Linux
Difference between gzip and tar command in Linux
Views: 757 Subhroneel Ganguly
How to select top N records using nested query in pl / sql
Online Training video to guide you how to select top N records using nested query in pl / sql.
Views: 2787 Subhroneel Ganguly
Run Jasper Report in Jasper Report Server with oracle datasource
Configure Jasper Report Server, uploading jrxml reports developed in Jasper Studio, configuring data source for oracle database connection.
Views: 2296 Subhroneel Ganguly
How to invoke oracle plsql function from jsp.
This oracle tutorial is about calling a function from Oracle database 12c release 1 from JSP module without using select statement. Only two object is used. One connection object and another callable statement object.
Views: 1655 Subhroneel Ganguly
Building Matrix with Group Report using Oracle Report Builder 6.0
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
How to use Format Trigger In Oracle Report Builder 6i to filter record in Report Layout
Views: 18250 Subhroneel Ganguly
Creating Login Page with Struts 2....
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
Using Google Map Geolocation API with AngularJS.
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
How to change font size in HTML page dynamically.
How to change font size in HTML page dynamically using Java Script. Code link is given below. http://techgigsonline.blogspot.in/2014/09/how-to-change-font-size-in-html-page.html
Views: 1734 Subhroneel Ganguly
Python sending email using smtp
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
How to use Google Maps with AngularJS
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
HTML template binding using ng-repeat with filter orderby in AngularJS.
AngularJS is a JavaScript framework, open source web application, perfect tool for single page application. It strictly follow the MVC architecture. Here is an example of AngularJS program to demonstrate how ng-repeat works and how searching can be done by piping filter to optimize search capability and sorting by piping orderBy. Source Code link : https://drive.google.com/file/d/0BznrW3lgX0ozMXhWY29tNnBrbHc/view?usp=sharing
Views: 1243 Subhroneel Ganguly
Optimize Code with Merge Statement in Oracle PLSQL.
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
:Old and :New value in pl sql triggers
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.
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
How to create a Custom ToolBar in Oracle Forms.
How to create a Custom ToolBar in Oracle Forms using toolbar canvas Adding buttons to the toolbar, writing PL/SQL trigger to the button.
Views: 9734 Subhroneel Ganguly