i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
HCL,
1746In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
1898I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?
L&T,
8 14220After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?
1607A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?
2 4542I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.
1 3204I have a reference table called 1. of 2 fields called 1.BadgeGroups(BG)and 1.Badges(B)like BG G aa 10 aa 11 bb 12 bb 13 bb 14 Using MS Design View Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group In Table 2 called 2. they calls Table 1 for 2 fields BUT with the second field 2.badges, I want the combo box only to display the 1.badges where 2.badgegroup = 1.badgegroup The current select I have is for Table Data View Row Source is: 2.badgegroup is filled from a Combo box using Select Distinct etc from Table 1. Tried different syntax's but still lost, looking for some help SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE 1.[BadgeGroup]=Me.2.BadgeGroup); I can populate 2.badgegroup with a
1945What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)
1 11172
Explain table queries and select queries. What are the main differences between the two?
What will be the maximum number of indexes per table?
what are the different kinds of indexing?
Enlist the advantages of dbms.
How do you create a table in microsoft access?
What is oracle open database communication (odbc)?
What is difference between group by and order by clause?
Does ms access use sql?
What is tee command in mysql?
Can multiple columns be used in group by in oracle?
What is the role of tester in discovery(in Checklist)?
What is field with example?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
what are the new features introduced in sql server 2000? : Sql server database administration
What do you mean by SQL injection attack?