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: 11205 Subhroneel Ganguly
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: 12680 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: 6403 Subhroneel Ganguly
How To Start Or Stop Oracle Service In Red Hat Linux Enterprise 6.0.
Views: 13674 Subhroneel Ganguly
Views: 20841 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: 42546 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: 57893 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: 10961 Subhroneel Ganguly
This training video shows how to call Oracle Reports run-time from Oracle Forms 6i using runproduct functions.
Views: 26065 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: 7433 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: 25699 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: 12932 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: 17097 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: 2847 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: 9892 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: 8611 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: 121273 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: 5696 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: 7554 Subhroneel Ganguly
How to start, stop or restart Network Service in Red Hat Enterprise Linux 6.0.
Views: 3084 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: 9327 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: 9081 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: 212414 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: 2312 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: 9425 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: 19084 Subhroneel Ganguly
Using an inline view in an sql statement in SQL/PLSQL
Views: 2590 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: 52459 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: 1284 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: 27173 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: 2815 Subhroneel Ganguly
How to use Format Trigger In Oracle Report Builder 6i to filter record in Report Layout
Views: 17741 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: 12300 Subhroneel Ganguly
Views: 1951 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: 12621 Subhroneel Ganguly
How to Create List of Values (LOV) in Oracle Forms 10g
Views: 12135 Subhroneel Ganguly
How to create Control Event Handler in Visual Basic 6.0. Control events are fired whenever there is activity on that control with user intervention or automatically, We have created handler that can handle events related to particular control,
Views: 3525 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: 1459 Subhroneel Ganguly
Configure Jasper Report Server, uploading jrxml reports developed in Jasper Studio, configuring data source for oracle database connection.
Views: 2054 Subhroneel Ganguly
Online Training video to guide you how to select top N records using nested query in pl / sql.
Views: 2745 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: 10856 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: 1600 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: 2424 Subhroneel Ganguly