What is self contained sub query?

1129

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

2201

How to convert numeric expression data types using the cast() function?

1133

How to provide default values to function parameters?

1235

What are the two main functions of queries in databases?

1509

What is temporary table in sql server? Why we use temp table?

1000

How to put more than 1000 values into an oracle in clause?

1095

How raid can influence database performance?

1093

How do I find the sql server version?

1096

what is dbms? : Sql dba

1048

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1277

What are different types of constraints?

981

How do I find query history in sql server?

1000

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

1061

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

1136