Hi Natraj What I will suggest you is to do the following: (1) Update the create script above to change the "CALCULATION" column be VARCHAR2(50). This column will store the formula in which the user
Good day Natraj Here is an example: -- Create First Record CREATE TABLE "ECEBI"."FIRST_RECORD" ( "RECORD_ID" NUMBER, "LENGTH" NUMBER, "BREADTH" NUMBER, "HEIGHT" NUMBER, "CALCULATION"
Hi Shailendra, Please see the results of following query for the exact constraint_name which is disabled. select table_name, constraint_name, status, validated from user_constraints where constraint_name
HI Kumar, If your table is being used as a temporary table to store values, then it's possible that it can grow quickly. You need to understand the application that is using the table to understand
Hi Natraj, To execute a stored procedure from within Oracle's SQLPLUS, you can either use: SQL> execute my_store_proc (var1, var2, ... var x) where var1, var2 ... var x dependes on the number