Profile cover photo
Profile photo
V. Kapoor
836 followers -
This website is dedicated to my father Shri Munish Kapoor
This website is dedicated to my father Shri Munish Kapoor

836 followers
About
Posts

Post is pinned.Post has attachment
Public
Add a comment...

Post has attachment
In this tutorial, You will learn how to drop an Oracle Database in Windows. The following are the Oracle database and Windows version details used in this example: Oracle Database 11g Windows 10 Steps To Drop an Oracle Database 11g in Windows 10 Click on…
Add a comment...

Post has attachment
There are two ways to run an SQL script in Toad. The following are the examples. Run SQL Script in Toad for Oracle Method – 1 Open Toad and connect to the database. Then click on the menu Database > SQL Editor. In SQL Editor, give the same command…
Add a comment...

Post has attachment
In Toad, it is effortless to execute Explain Plan for an SQL query and also very comfortable to read. Follow these steps to view Explain plan in Toad. Explain Plan For an SQL Query in Toad For Oracle In Toad, Open SQL editor by clicking on the menu…
Add a comment...

Post has attachment
In this tutorial, you will learn how to connect Oracle Database in JDeveloper. JDeveloper version used for this example is 12c and following is the Oracle Database information to which we connect: ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =…
Add a comment...

Post has attachment
In Oracle SQL Developer, if you will try to import an XML file using the Import menu option, then you will not find a choice to import as XML. There are only three options exists in Oracle SQL Developer even in the latest version 18.2, and they are CSV,…
Add a comment...

Post has attachment
To change the date format in Toad for Oracle follow these steps. Steps to Change Date Format in Toad For Oracle In Toad, click on the menu View > Toad Options. Then Options window will open. In the Options window, click on the Data option under Data Grids…
Add a comment...

Post has attachment
In Python, you can create an empty class by using the pass command after the definition of the class object, because one line of code is compulsory for creating a class. Pass command in Python is a null statement; it does nothing when executes. The…
Add a comment...

Post has attachment
In Oracle Forms, if you are creating any custom login screen or giving any password security option, then there is a need to hide the password. This method is a standard also for a password field that it should protect the password by displaying any other…
Add a comment...

Post has attachment
You have executed a query in Oracle SQL Developer, and now you want to view the execution time for that SQL query. Below is a tip to how to find query execution time in Oracle SQL Developer. Find Query Execution Time in Oracle SQL Developer Before running…
Add a comment...
Wait while more posts are being loaded