Is inner join faster than left join?

1273

Can we use distinct and group by together?

1129

What is oracle latest version?

1168

What is a view in sql?

1035

how to start mysql server? : Sql dba

1258

How to select all columns of all rows from a table in oracle?

1118

List the ways in which dynamic sql can be executed?

1077

How can you append an identity column to a temporary table?

1063

Can you index views?

951

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

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

1235

How to connect php with different port numbers?

1173

How can I check that whether automatic statistic update is enabled or not?

1108

what is collation? : Sql dba

1224

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841