-
How can your find the Oracle version you are running..?
SELECT * FROM V$VERSION
Read Best Answer
Editorial / Best Answer
Answered by: Mohammed Abdul Afroze
- Sep 27th, 2007
To find the Oracle Version:
Sql>Select * from v$version;Mohammed Abdul Afroze
- Sep 27th, 2007
To find the Oracle Version:Sql>Select * from v$version;
-
Can any one tell me what are the subject areas(like Billing, Accounts etc.) that are there in Teradata FSLDM --> Financial Services Logical Data Model (Teradata FS-LDM 7.0) .
singapore_li
- Sep 15th, 2006
Subject AreasParty,Party Asset,Location,Campaign,product .................
singapore_li
- Sep 15th, 2006
FSLDM COnsists of 10 Subject Areasparty,party asset,address,compaign.......
-
I have a production 24/7 database and i am looking at refreshing the database, how is it possible ? Mind you ! Its a production 24/7 database nad hence cannot be shutdown ?
Read Best Answer
Editorial / Best Answer
msvkrishna- Member Since Feb-2009 | Feb 11th, 2009
Why do you have to refresh a production database and with what will you refresh? You can refresh a Dev or Test Db. For production db you need to have a hot backup.
msvkrishna
- Feb 11th, 2009
Why do you have to refresh a production database and with what will you refresh? You can refresh a Dev or Test Db. For production db you need to have a hot backup.
Chiranjeevi Manne
- Mar 30th, 2007
Go for Replication using either Oracle Streams or Quest Shareplex
-
How to get a calender in date field in oracle forms?
ANURAG
- Oct 22nd, 2016
How do we configure that? Any help would be appreciated...
-
-
How many codds rule should oracle satisfies
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. -
What is the difference between DBMS and RDBMS ?
Read Best Answer
Editorial / Best Answer
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
- 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...
Read Best Answer
Ans