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

822 followers
About
Posts

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

Post has attachment
You can connect database in Oracle Forms builder using TNS (tnsnames.ora file) and by using the direct method (without tnsnames.ora file). The direct way is same for Oracle Forms 10g and 11g and even for 12c. But using TNS, a little difference is there…
Add a comment...

Post has attachment
You can disable a menu item in Oracle Forms in design time and at runtime. Design time you need to set enabled property manually for the menu and at runtime, you can disable the menu item using SET_MENU_ITEM_PROPERTY built-in. Below are the examples of…
Add a comment...

Post has attachment
To create a function in PL/SQL, use CREATE OR REPLACE FUNCTION statement. Below are the syntax details and an example. Syntax CREATE [OR REPLACE] FUNCTION function_name [(parameters)]  Return data_type is /* declare variables here / Begin / write…
Add a comment...

Post has attachment
In this article, I am giving an example of a function which I mostly use to split a string in PL/SQL. Especially, when I am writing a program to import a delimited file. Here are that function and an example of how to use it. PL/SQL Function to Split a…
Add a comment...

Post has attachment
In Oracle Forms, we required to add scrollbars when we create a tabular data block with multiple records or a stacked canvas. For tabular data block a scrollbar belongs to the data block and for stacked canvas, a scrollbar is belong to the canvas. Below…
Add a comment...

Post has attachment
To index, a web page on Google follow these steps. Steps to Index a Web Page on Google Search Console Open the Google Search Console. On the left side, click on Crawl to expand the node. Then click on Fetch as Google, as shown in the below image. In the…
Add a comment...

Post has shared content
You can find the directory objects in Oracle using data dictionary view DBA_DIRECTORIES and ALL_DIRECTORIES. The following are the examples. Find Directory Objects in Oracle In the following example, we will find the directories using DBA_DIRECTORIES…
Add a comment...

Post has shared content
In Oracle, Synonyms are alternative names for database objects and a synonym can be a public or private. A PUBLIC and able to be used by all users, and PRIVATE, that is, used by only the defining user. Private synonyms cannot have the same name as…
Add a comment...

Post has shared content
To generate a schema script from Toad for Oracle follow these steps. Generate Schema Script in Toad for Oracle In Toad, click on the menu Database > Export > Generate Schema Script option. The Generate Schema Script window will open. Select the schema…
Add a comment...
Wait while more posts are being loaded