select count(1) from emp? what is the o/p?

Answer Posted / moorthy g

select count(1) from emp;

Count(1):
14
It will display how many records in emp table
Total 14 Records are there in my table.
Correct If I'm wrong
Regards,
Moorthy

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain dynamic target flat file name generation in informatica

652


Can we create multiple integration service on single repository?

705


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1136


Can you use flat files in Mapplets.

2226


How do you use reject loader.

2073






Explain what transformation and how many are there in informatica?

489


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6485


explan ur project architecture?

1599


What are the prerequisite tasks to achieve the session partition?

715


What is pmcmd command?

677


What are the guidelines to be followed while using union transformation?

642


How can a transformation be made reusable?

666


What is meant by a domain?

631


Name the different lookup cache(s)?

711


How can we update a record in the target table without using update strategy?

658