kannan1983
Last Activity: Sep 14 '07, 12:23 PM
Joined: Aug 14 '07
Location:
-
View
Can anyone tell me Is there any constraint like we should not create a view on parent table if yes can any one explain why? -
External table
Can any one tell me the concept of external table and an example for this -
constraint
Can anyone give me an example of enable constraint with no validate option and explain -
constraint
Can any one give me an example of enable constraint with no validate option and explain -
execute immediate statement
what is the difference between
TRUNCATE TABLE table_name
and
EXECUTE IMMEDIATE'TRUNC ATE TABLE table_name'
is there any performance issue between this two?
which is best to use in procedures? -
when i executed the above DDL All the tables are created successfully , i think the code is fine...Leave a comment:
-
checking null values
In a table i have to check each and every column for null values . if the column has null value i need to display as ' NULL VALUE' in the output , for these iam declaring some local variables
Iam checking the column for null value using IF ( col_name IS NULL)
if the column has null value ill assign the variable as null value or else ill assign the value which is there in the column
another thing we can use NVL2 function... -
check whether a value is valid year or not in oracle
how can we check whether a value is valid year or not in oracle , please give your suggestions -
catch invalid date value
Iam having a column which contains year (e.g 2005,2006), i have to validate each and every value in this column, if it is like(e.g.20005, 20600,200060006 ) i have to caputure this value , for that i have used
i_date:= to_date (i_year,'yyyy') ;
here i_date is a DATE datatype , if i_year is like(20005 or 20600) it will thrown an exception number , i used that number to make a user_defined exception... -
validate year is numeric
I have column in a table which contains year(e.g 2006,2007),here i have to check the values in the column that all are numbers(e.g. it should be like 2006 not like 'a206' or 'abc6'), i have to check each and every value in that column if any value is invalid i have to insert that values in a table
No activity results to display
Leave a comment: