 Related Questions Latest Answer : Primary Key & Unique Key1.))) P_key - A column in a table whose values uniquely identify the rows/tuple/entry of the table. A primary key value cannot be NULL. U_key - A column in a table whose values uniquely identify the rows/tuple/entry of the ... Latest Answer : null in c is some garbage value which cannot be predicted . If you are not intialising any value to the variable then null value is present in auto variables.null in oracle is used in sql queries for getting values whose values are null such as manger ... Latest Answer : What's the Difference between COM and DCOM?Obviously, the difference is that DCOM is distributed but COM is not. To be more precise, there are three main elements added to COM: The way for creating a remote object. The way for accessing a remote object. ... Read Answers (1) | Asked by : satish Latest Answer : SGA: System Global Area. Its a chuck of memory used on oracle processes. ... Read Answers (23) | Asked by : Rahul Latest Answer : In case of varchar it store upto 2000 bytes and in case of varchar2 it stores 4000 bytes that is the basic difference between varchar and varchar2. ... Read Answers (21) | Asked by : Srinu Latest Answer : replace function replaces a sequence of characters in a string with another set of characters.ex. Â select replace('123data',123,'X') from dual;REPLA-----Xdatahere 123 replaces by Xtranslate function replaces a sequence of characters in a string with ... Read Answers (9) | Asked by : Srinu Latest Answer : rownum is the temp num assigned for the return rows per statement queryIt will change as per the query statement.
It can be used with "=1" or "< 10" id number .Where as rowid is the id assigned by the
Oracle while creating record in database. It ... Read Answers (6) | Asked by : senthil Write a query that displays the difference between the highest and lowest salaries. Label the column Write a query that displays the difference between the highest and lowest salaries. Label the column DIFFERENCE. Latest Answer : Instance is the memory structures and background processes used to interact with Database.Instance = SGA + Background ProcessDatabase is the physical files used to store information. the 3 types of physical files are: Datafiles, Control File and ... Read Answers (1) | Asked by : Mohammed Abdul Afroze Latest Answer : Cold Backup is possible only when the database is down means it is not available to users to access. Disadvantage is we effort downtime. Here we need to take backup of datafiles, control files, redo files. Here we get consistent backup image.Hot backup ... Read Answers (4) | Asked by : Sridhar Tags : Backup
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
1