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: 11615 Subhroneel Ganguly
How To Start Or Stop Oracle Service In Red Hat Linux Enterprise 6.0.
Views: 13136 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: 10743 Subhroneel Ganguly
Views: 20272 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: 41881 Subhroneel Ganguly
This training video shows how to call Oracle Reports run-time from Oracle Forms 6i using runproduct functions.
Views: 25562 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: 56178 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: 6416 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: 10512 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: 5045 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: 9649 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: 10848 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: 25263 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: 8636 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: 2625 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: 7497 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: 8364 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: 15267 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: 5409 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: 118033 Subhroneel Ganguly
How to start, stop or restart Network Service in Red Hat Enterprise Linux 6.0.
Views: 2987 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: 210828 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: 2189 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: 9065 Subhroneel Ganguly
Using an inline view in an sql statement in SQL/PLSQL
Views: 2552 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: 26679 Subhroneel Ganguly
Building Matrix with Group Report using Oracle Report Builder 6.0 and Oracle Database 11g database.
Views: 5224 Subhroneel Ganguly
How to add Values dynamically To ListBox In Oracle Forms using Creategroupfromquery / Add_list_element
Views: 2677 Subhroneel Ganguly
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: 2266 Subhroneel Ganguly
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: 1210 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: 18851 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: 52100 Subhroneel Ganguly
How to Create List of Values (LOV) in Oracle Forms 10g
Views: 11899 Subhroneel Ganguly
Views: 1902 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: 2672 Subhroneel Ganguly
Configure Jasper Report Server, uploading jrxml reports developed in Jasper Studio, configuring data source for oracle database connection.
Views: 1820 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: 11836 Subhroneel Ganguly
How to use Format Trigger In Oracle Report Builder 6i to filter record in Report Layout
Views: 17186 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: 12160 Subhroneel Ganguly
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: 9404 Subhroneel Ganguly
Online Training video to guide you how to select top N records using nested query in pl / sql.
Views: 2688 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: 10618 Subhroneel Ganguly
How to implement when validate trigger in Oracle Forms. Implementing when-validate-item trigger and when-validate-record trigger, use of this triggers at item and block level.
Views: 1543 Subhroneel Ganguly
How to install Oracle Developer Suite 10g on Windows. Online training video Install Oracle Developer Suite and configure Service name with Net Easy config.
Views: 17811 Subhroneel Ganguly