How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?
1 6195I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...
3 6737I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....
3 6333column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
4 7496how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
1 7076How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?
1 7236I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.
MTS,
7 10666
Why stored procedures are faster than query?
Why we use cross join?
Can we rename a column in the output of sql query?
What are the types of views in sql?
What is the difference between a procedure and a function?
Is vs as in pl sql?
Can we create clustered index without primary key?
Are stored procedures faster than queries?
What are triggers and its types?
what is query cache in mysql? : Sql dba
When can we use the where clause and the having clause?
What is bulk collect in pl sql?
how many sql dml commands are supported by 'mysql'? : Sql dba
What are tables in sql?
How do I get sql certification?