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) i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
1949which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
4 5518I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?
2 4068I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
IBM,
1553First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
IBM,
1740While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?
HSBC,
2 8028My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?
CG,
2 4510I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?
HSBC,
2 7570Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
HSBC,
5 136772) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID
2 4950I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?
1 3138
What is data source object?
Why we should not use triggers?
What is mysql optimization?
Define self join?
Is mongodb better than other sql databases? If yes then how?
Can we create view in stored procedure?
What you can use regular expression for in mysql? Support your answer with an example?
What are materialized views & where do we use them? What is a materialized view log?
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
What is user and end user?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Is nosql database types?
What is cross join sql?
How can I check if a view exists in a sql server database?
Can we use jpa with mongodb?