Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288) Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.
CGI,
5 8387hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
HP,
2385Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name, price 101, LED Lights,200 102, 20 watt CFL Lights, 145 103, 30 watt CFL lights,155 Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence flat file product list has two column pro_name, price 20 watt tube light ,45 30 watt tube light ,60
TCS,
1 5845Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
2023
Who introduced dbms?
Mention what is the difference between instance recovery and crash recovery?
Explain about query and reporting.
What is the maximum length of an alert name?
Which is the correct statement about truncate and delete?
What is a livelock?
Differentiate between pl/sql and sql?
What are features of mysql?
What is the difference between clustered and a non-clustered index?
What is cql? How to execute cql commands in neo4j?
What is %type in sql?
What is it’s similarity with sql server?
Advantages and disadvantages of stored procedure?
Mention the uses of stored procedures.
What are the basic sql commands?