I have two Table A and B.With table A I fired a query to get a count, and a query with table B to get a count.now I want total of both count.But I want to this all in one query.Example:- I fired tqo queries as-1- select DATE(Today_DATE), count(1) from table DAY1 group by DATE(Today_DATE);2- Select DATE(Yesturday_DATE), count(1) from table DAY2 group by DATE(Yesturday_DATE);Here both table give separate...

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Jan 3rd, 2013

You can do it like this

SELECT (SELECT COUNT(1) FROM table DAY1 GROUP BY DATE(Today_DATE)) + (SELECT COUNT(1) FROM table DAY2 GROUP BY DATE(Yesterday_DATE)) AS TotalCount FROM day1 LIMIT 1

Answer Question  Select Best Answer

Hi friends,
I m 2012 pass out in CSE discipline. And recently joined Cybage Software as Production Support Engineer. But my ultimate goal lies in Database System. So joining Cybage was merely to keep relatives shut up and parents happy as well as prepare for my goal. But right now I have gone through various sites stating that jobs in DBA is tough to get, for freshers. And also...

DBA

• Feb 15th, 2013

Hope you are aware that being a DBA means working odd hours , indiscriminate routines , erratic week-offs ,etc (occupational hazards ! ) Even then if you wish to take this career option ,here is the w...

Answer Question  Select Best Answer

Difference b/w client server and web based applications?

divya

• Mar 9th, 2013

Client server application refers to an application which has client and its own server. Client can be an employee of an organisation and server of that organisation. For example: College SERVER HAS ...

Answer Question  Select Best Answer

ashu

• Mar 20th, 2013

Are you talking about EF Codds 12 rules?

I seem to recall that Oracle has satisfied MAX of 12, with the exception being that the empty string is treated as a NULL.

rojalinpanigrahi

 Profile Answers by rojalinpanigrahi Questions by rojalinpanigrahi

• Sep 30th, 2008

Oracle should satisfy 13 rules of codd

Answer Question  Select Best Answer

santosh varma

• Mar 21st, 2013

Check in v$dba_datafiles where the datafiles will start with prefix + are asm data bases

Answer Question  Select Best Answer

How to delete duplicate records in Teradata?

ram

• Apr 2nd, 2013

SELECT column names from party group by column names;

Use Distinct or Qualify

Answer Question  Select Best Answer

While installing Oracle 10g in window 7 it is giving error------
Abnormal Program termination.An internal error has occurred . Please provide the following files to Oracle support:
"Unknown" "Unknown" "Unknown"

Oracle2066

• Apr 26th, 2013

The question is over 2 years. How can you run windows Compatibility troubleshooter on an Oracle Internal error? It is not possible period. Please revisit Oracle Internal errors documentation at Oracle...

sushant

• Apr 26th, 2013

Just open control panel then click to Action Center ..There U will find the Window Programs Troubleshooting Compatibility Click that and browse the program u want to install

Answer Question  Select Best Answer

I have a request about adding new application at existing oracle 11gr2 database.

What questions should I raise with the vendor about there application. Please give my answer at your earliest possible time, because my management waiting for the answers.

Thanks in advance.
Ibrahim

How d you ensure end to end test coverage in ATDD process as functionality are delivered in pieces in different sprint?

Im trying to create a traceable database for work using Access, and im finding that even though i have all the data i need and everything to trace where everything goes i cant seem to get my queries to work. I need to have Table A, B, and C connect to D and connect to E with a query at E to go backwards to the other tables. A, B,and C dont have any relationships that connect them but they all connect...

ritam mitra

• Aug 30th, 2014

First try to check the join or connection between all the tables are proper, then create a view and then run query. it will work

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

RicGupta1984  

 Profile Answers by RicGupta1984 Questions by RicGupta1984

• Member Since Sep-2007 | Mar 5th, 2008

---

A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some uniform methods independent of a specific application for accessing the information that is stored.

RDBMS is a Relational Data Base Management System Relational DBMS. This adds the additional condition that the system supports a tabular structure for the data, with enforced relationships between the tables. This excludes the databases that don't support a tabular structure or don't enforce relationships between tables.

Many DBA's think that RDBMS is a Client Server Database system but thats not the case with RDBMS.

Yes you can say DBMS does not impose any constraints or security with regard to data manipulation it is user or the programmer responsibility to ensure the ACID PROPERTY of the database whereas the rdbms is more with this regard bcz rdbms difine the integrity constraint for the purpose of holding ACID PROPERTY.

asif shaikh

• Nov 22nd, 2014

And other major difference are dbms does not support constraints and normalization.

prashant_hcu

 Profile Answers by prashant_hcu Questions by prashant_hcu

• Aug 1st, 2010

DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some un...

Improve Answer

Create the flowchart and algorithm for a module that will prompt the user to enter their height in feet and inches (two separate input values). The program should output “Guard” if the user is under 6’4”, “Forward” if the user is between 6’4” and 6’10”, and “Center” is the user is over 6’10”.

Nupur

• Apr 25th, 2015

1.declare variables ft and inch.
2. Enter the values.
3. Check for validity using case statement .
4. Print on screen using dbms_output.put_line

Answer Question  Select Best Answer

1) What is meant by Joint DEPENDENCY in normalization?
2) What is a MULTIVALUED DEPENDENCY? Explain.

shivakumar

• Jan 12th, 2016

When you decompose a relation into sub relations and when you assembled those sub relations it should result in original loss-less relation. Such dependency is called join dependency. Example relation...

Athira.m.m

• Oct 12th, 2015

You see joint dependency means that when you decompose tables those decomposed table should satisfy JOIN dependency ie., when they are joined they should make the original table without any conflicts ...

Answer Question  Select Best Answer

Hi..I am a student and I am learning software quality assurance subject...I want to know how to writes test cases for an email inbox of an email account.I will be very thankful to u

Mukesh

• Oct 1st, 2016

Hi swagatika,
well written
but in case here is lots of things like Compose, Sent Mail, Draft, how to close Draft etc

swagatika

• Jan 10th, 2015

Pre Condition: 1-Device connected to open internet, able to access in the internet 2-Access the URL Steps: 1-Access www.gmail.com->login page->Enter created emailid and pwd 2-Click inbox field ->op...

Answer Question  Select Best Answer

ANURAG

• Oct 22nd, 2016

How do we configure that? Any help would be appreciated...

Enamul

 Profile Answers by Enamul Questions by Enamul

• Jul 9th, 2008

At first configure webconfig file that have in server folder.

Answer Question  Select Best Answer

eswar

• Dec 28th, 2016

Basically a simple and complex views can be differentiated based on the relations, functions and groups of data not by number of tables in the views. Ex: We can not apply Insert, Delete and Update on...

Bahadar Ayaz

• Jul 20th, 2011

Here are few differences between simple and complex views. 1. A Simple view selects from one table. A Complex view selects from one or more tables. 2. A Simple view does not contain functions but Com...

Answer Question  Select Best Answer

What is modules

• Feb 24th, 2017

In easy language for beginner

Jai pal reddy

• Jun 9th, 2007

Set con=createobject("ADODB.connection")set rs=createobject("ADODB.recordset")set cmd=createobject("ADODB.command")con.provider=(Microsoft.jet.oledb.4.0")con.open "select the path of the database"rs.open "enter sql querry",con

Answer Question  Select Best Answer

Diwakar

• Oct 20th, 2017

AWR-Automiatic Workload repository is the report which provides finer details of work that was performed on DB during specific period. It provides following important details 1. Wait events causing...

Ora-Masala

• May 4th, 2016

The AWR is used to collect performance statistics including: Wait events used to identify performance problems. Time model statistics indicating the amount of DB time associated with a process fro...

Answer Question  Select Best Answer

Diwakar

• Oct 20th, 2017

Anonymous block is independent piece of code to implement certain pseudo code. subprogram are some named entities like procedure and function which can be invoked from outside window.

YES procedure can be invoked using anonymous block.

Nupur

• Apr 25th, 2015

Answer to second part of the question : yes we can call a procedure from an anonymous block

Answer Question  Select Best Answer