Computer Certification

Recent Answers

2013-05-30 Oracle - Executing a formulae in a field:

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

2013-05-28 Oracle - Executing a formulae in a field:

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"

2013-05-24 Oracle - unique constraint voilated:

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

2013-05-23 Oracle - table size is increasing abnormally:

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

2013-05-17 Oracle - Executing a formulae which is in a field:

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