We are explaining here Oracle Forms Architecture Features in R12/R12.2 Features of Forms in R12 -forms are deployed as a one One OC4J instance of 10.1.3 Oracle home-It uses the utility from 10.1.2 Oracle home/bin-Forms.EAR 10.1.2 is deployed to the OC4J container in Application Server 10.1.3-Run time form executable f60webmx has been replaced by frmweb-Forms …
Oracle Forms in R12/R12.2 Read More »
What is a Bind Variable? -It is a placeholder for a value .It is replaced by actual value when the SQL statement is executed-In PL/SQL it is called a local or global variable. DECLARE l_empl_id DEPT.emp_id%TYPE; BEGIN select first_name from DEPT where id = l_empl_id; END; -in SQL*Plus it is a variable variable a number BEGIN …
Improve the Performance using Bind Variable in Oracle Read More »
When you create an Oracle table, you have to specify a datatype for each column, which is associated with a specific storage format, constraints, and a valid range of values. The knowledge of data types is necessary before creating the table. Here in this article, we will see important oracle data types which you will …
ORA-01017 is one of the common errors seen while connecting to the Oracle database. Here is what the documentation says about this error Here is the checklist to run to resolve the ORA-01017: invalid username/password (1)The main issue with an ORA-01017 error is an invalid user ID and password combination. You have to make sure,you …
Here in this post we will see weblogic patching i.e how to apply patches applied in weblogic in 10.3.6 version , 12c (12.1.1 and 12.1.2 and later ). how to apply patches in weblogic in 10.3.6 version and up to 12.1.1 Weblogic Smart Update utility (bsu) is used to apply patches in 10.3.6 and 12.1.1 …
How to apply patches in Oracle weblogic in Linux & windows Read More »
Here we are presenting ways on how to move lob segment from one tablespace to another (1) First take the initial size of the LOB segment SELECT table_name, column_name, segment_name, a.bytes FROM dba_segments a JOIN dba_lobs b USING (owner, segment_name) WHERE b.table_name = ‘TABLE_NAME’; More queries can be found at How to find space usage …
how to move lob segment from one tablespace to another Read More »
