Answer Posted / mohit gupta
Null is a value that is unavailable, unassigned and unknown.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Use of an integrity constraint is better to validate data. Explain
What is the usage of merge statement?
List the parts of a database trigger.
What is meant by joins?
What is a subquery in oracle?
How to define and use table alias names in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Where do you use decode and case statements?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What are the differences between date and timestamp in oracle?
Explain drop constraint oracle?
Is there any function in oracle similar like group_concat of mysql?
What happens if you use a wrong connect identifier?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to create id with auto_increment on oracle?