Explain “row_number()” in sql server with an example?

1069

How to export data from database and import into another?

989

What are the properties of the transaction?

1069

How to write a left outer join with the where clause in oracle?

1149

Is there some bulk load or other way to import a lot of data fast?

929

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2207

Is it possible to have clustered index on separate drive from original table location?

1034

Is primary key always clustered index?

1090

If a cursor is open, how can we find in a pl/sql block?

1235

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2306

What is sql or structured query language?

1217

Have you used lexical parameters in reports?

38

What is the difference between case version and decode version?

1102

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1945

How do I find query history in sql server?

1018