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 5738I 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 6057I 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 5685column 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 6712how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
1 6515How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?
1 6786I 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 9602
what is offset-fetch filter in tsql? : Transact sql
How to Execute a Package in PL/SQL.?
What is sql mysql pl sql oracle?
How many types of cursors supported in pl/sql?
what is the difference between blob and text? : Sql dba
What is group by in sql?
What is range partitioning?
What is the mutating table and constraining table?
What is spool?
When is the update_statistics command used?
Is left join inner or outer by default?
What is difference between inner join and self join?
Can we use ddl commands in pl sql?
What are inbuilt functions in sql?
Why use subqueries instead of joins?