State the first_defined function with an example?




Answer Posted / hamshapriya

This function is similar to the function NVL() in Oracle database

- It performs the first values which are not null among other values available in the function and assigns to the variable

Is This Answer Correct ?    0 Yes 0 No






Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is the partitioning with key different from round robin partition?

32


When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

37


I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?

993


What is the difference between look-up file and look-up, with a relevant example?

34


What is a deadlock and how it occurs?

50






Mention what information does a .dbc file extension provides to connect to the database?

30


Mention what are the different types of parallelism used in abinitio?

30


What is the difference between sandbox and EME?

55


What do you mean by the overflow errors?

52


Is data warehousing different from data mining?

29


Mention what is the role of co-operating system in abinitio?

35


What is a look-up?

48


What is the syntax for m_dump in abinitio?

62


Have you ever encountered an error called “depth not equal”?

35


Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

35