Home
Videos uploaded by user “Subhroneel Ganguly”
Migrate SQL Server Database to Oracle using SQL Developer
 
09:05
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: 11663 Subhroneel Ganguly
How To Start Or Stop Oracle Database Service In Red Hat Linux Enterprise 6.0.
 
06:15
How To Start Or Stop Oracle Service In Red Hat Linux Enterprise 6.0.
Views: 13159 Subhroneel Ganguly
Connect Crystal Report to SQL Server and call from VB6.
 
13:35
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: 10765 Subhroneel Ganguly
Add or remove data in html table using AngularJS
 
14:30
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: 20301 Subhroneel Ganguly
Install and Configure Oracle Weblogic Server on Windows.
 
26:31
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: 41900 Subhroneel Ganguly
Create web service in visual studio 2010 to retrieve data from SQL Server.
 
16:22
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: 56253 Subhroneel Ganguly
Connect to Mysql db from Oracle Sql Developer
 
12:00
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: 6456 Subhroneel Ganguly
How to call Oracle Reports run-time from Oracle Forms using Runproduct.
 
16:29
This training video shows how to call Oracle Reports run-time from Oracle Forms 6i using runproduct functions.
Views: 25590 Subhroneel Ganguly
How to create and use database link in Oracle
 
15:50
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: 5091 Subhroneel Ganguly
How to pass parameters from one form to another in Oracle forms.
 
12:37
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: 10531 Subhroneel Ganguly
Creating Jasper report from Oracle data source.
 
14:07
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: 4774 Subhroneel Ganguly
How to Connect To Oracle 11g Database Using JSP.
 
19:48
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: 25289 Subhroneel Ganguly
Retrieve data from Oracle database using ajax and angularjs
 
17:29
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: 9654 Subhroneel Ganguly
How to create and monitor scheduled jobs in Oracle
 
14:49
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: 8671 Subhroneel Ganguly
Connecting to DB2 database using SQL Developer and jdbc driver.
 
09:20
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: 10941 Subhroneel Ganguly
Configuring Linked Server in SQL Server to connect to Oracle database
 
11:17
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: 15339 Subhroneel Ganguly
How to create custom properties in Visual Basic 6 Usercontrol.
 
21:40
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: 2638 Subhroneel Ganguly
Collection methods in PLSQL Oracle.
 
26:09
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: 7497 Subhroneel Ganguly
How to write post query trigger in Oracle Forms.
 
06:57
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: 8375 Subhroneel Ganguly
Oracle PLSQL Functions more examples
 
28:49
Oracle PLSQL Functions more examples
Views: 1919 Subhroneel Ganguly
Working with dates in Oracle PLSQL.
 
23:34
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: 5430 Subhroneel Ganguly
How to connect to Oracle Database using Toad for Oracle.
 
08:42
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: 118199 Subhroneel Ganguly
How to start, stop or restart Network Service in Red Hat Enterprise Linux 6.0.
 
07:00
How to start, stop or restart Network Service in Red Hat Enterprise Linux 6.0.
Views: 2993 Subhroneel Ganguly
Difference between gzip and tar command in Linux
 
04:29
Difference between gzip and tar command in Linux
Views: 714 Subhroneel Ganguly
How to install and configure Oracle 11g Release 2 in Windows 64 bit
 
17:51
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: 210931 Subhroneel Ganguly
Using connectionless UDP protocol to send message using Python.
 
16:38
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: 2194 Subhroneel Ganguly
How to connect to Oracle database 12c from Developer 2000, Forms and Reports
 
04:40
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: 9073 Subhroneel Ganguly
Using an inline view in an sql statement in SQL / PLSQL
 
08:32
Using an inline view in an sql statement in SQL/PLSQL
Views: 2553 Subhroneel Ganguly
How to design and build Menu in Oracle Form Builder
 
20:08
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: 26715 Subhroneel Ganguly
How to add User Parameters in Oracle Reports.
 
13:09
This is a online training video on adding user parameters in Oracle Reports. Parameter configuration, calling reports from Oracle forms with parameter list.
Views: 10642 Subhroneel Ganguly
How to add Values dynamically To ListBox In Oracle Forms.
 
04:48
How to add Values dynamically To ListBox In Oracle Forms using Creategroupfromquery / Add_list_element
Views: 2682 Subhroneel Ganguly
How to enable SSL port for Apache Tomcat Server.
 
13:35
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: 18857 Subhroneel Ganguly
How to invoke oracle plsql function from jsp.
 
14:47
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: 1587 Subhroneel Ganguly
How to Add Control Into Forms in Visual Basic 6.0 at runtime.
 
14:18
How to Dynamically Add Control Into Forms in Visual Basic 6.0. This is an Online Training video to show how to add controls into forms at runtime.
Views: 2276 Subhroneel Ganguly
Using ajax $http.get in angularjs to retreive file JSON data
 
12:20
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: 52123 Subhroneel Ganguly
Building Matrix with Group Report using Oracle Report Builder 6.0
 
20:50
Building Matrix with Group Report using Oracle Report Builder 6.0 and Oracle Database 11g database.
Views: 5234 Subhroneel Ganguly
Visual attributes in oracle forms.
 
05:51
How to create visual attribute to highlight current record in Oracle forms. Current record visual attribute is an utility in Oracle forms to give special impression to you current record. It's just like templates which can be preset-ed with properties and later implement in you forms.
Views: 1214 Subhroneel Ganguly
How to use Format Trigger In Oracle Report Builder 6i
 
16:44
How to use Format Trigger In Oracle Report Builder 6i to filter record in Report Layout
Views: 17213 Subhroneel Ganguly
Add, Update, Delete Oracle data with AngularJS and JSP
 
19:44
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: 11873 Subhroneel Ganguly
How to Create List of Values (LOV) in Oracle Forms 10g
 
12:06
How to Create List of Values (LOV) in Oracle Forms 10g
Views: 11907 Subhroneel Ganguly
Adding shapes and markers in Google Map.
 
13:29
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: 1902 Subhroneel Ganguly
How to Create CSV from a database table using ADODB in VB6.
 
29:17
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: 2677 Subhroneel Ganguly
Run Jasper Report in Jasper Report Server with oracle datasource
 
20:16
Configure Jasper Report Server, uploading jrxml reports developed in Jasper Studio, configuring data source for oracle database connection.
Views: 1828 Subhroneel Ganguly
Sending Email from browser with AngularJS and Python script.
 
08:50
For sending email from browser using python and angularjs you need to enable execution of python script from browser. You can watch this- Executing Python Script from Web Browser using wamp server. https://www.youtube.comwatch?v=HXs_DgbLcb8 Also you can watch -Sending email with smtp using python. https://www.youtube.com/watch?v=SgrvJqjIB6o AngularJS helps to make your UI more dynamic while python do the backend job. Source Code : https://drive.google.com/file/d/0BznrW3lgX0ozeGFqOHBPYmVtQmM/view?usp=sharing
Views: 1809 Subhroneel Ganguly
How to select top N records using nested query in pl / sql
 
14:08
Online Training video to guide you how to select top N records using nested query in pl / sql.
Views: 2688 Subhroneel Ganguly
How to connect to Oracle 11g database from Crystal Report 11 release 2.
 
06:13
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: 12181 Subhroneel Ganguly
Return sys_refcursor through function in PL/SQL
 
08:13
How to return a set of Table row data through function using sys_refcursor in PL/SQL A simple tutorial to demonstrate using ref cursor in pl sql function opening and return ref cursor.
Views: 2947 Subhroneel Ganguly
Using Google Map Geolocation API with AngularJS.
 
28:38
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: 10630 Subhroneel Ganguly
How to add radio buttons in Oracle Forms.
 
11:36
How to add radio buttons in Oracle Forms. Add radio button in forms 6i, add radio group, radio buttons.
Views: 2834 Subhroneel Ganguly
Custom directive in angularjs..it's simply awesome!
 
17:32
How you seems to feel when you suppose get wings to fly. AngularJS is something like that to web developer, This AngularJS video demonstrate how to create custom directive in angularjs. Custom directives are a marker on DOM element that tell AngularJS's html compiler to attach a specific behaviour to that dom element or even transform the dom element and it's children. Source Code link of this tutorial : https://drive.google.com/file/d/0BznrW3lgX0ozdjdMU1pyZTNjbGM/view?usp=sharing Plunker limk : plnkr.co/edit/Bj2idf5VuXbo0ODye0i6 You can also look into the tutorial on : http://techgigsonline.blogspot.com/2015/01/list-of-custom-directives-in-angularjs.html
Views: 9409 Subhroneel Ganguly