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 6115I 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 6620I 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 6202column 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 7347how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
1 6971How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?
1 7153I 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 10449
How long will it take to learn pl sql?
What are variables in pl sql?
how to use case expression? : Sql dba
Does truncate free space?
Define sql delete statement.
What is a full join sql?
What does dml mean?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
How to add new employee details in an employee_details table with the following details
How long does it take to learn pl sql?
What is having clause in sql?
how can we know the count/number of elements of an array? : Sql dba
what is the difference between clustered and non clustered index in sql? : Sql dba
Is mariadb a nosql database?
Why do we use joins in sql?