 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 I hav oracle 9i installed on my server, and I am fireing a query as followsSelect distinct divisioncode from Mdivision Order By DivisionCodeWhen I fire this query in sql plus, it runs and give me results.but when I fire it thru asp script as follows rsDiv.Open sql,conn,3,1 while traversing thru the recordset on line if not rsDiv.EOF thenit is giving me following errorADODB.Recordset (0x800A0E78)Operation is not allowed when the object is closed.Pl. help me a.s.a.p. Read Answers (2) | Asked by : ashok 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 Create a query that display the last name,hire date and the day of the week on which the employee started. Label the column DAY. Order the results by the day of the week starting with Monday.LAST_NAME HIRE_DATE DAYGrant 24-MAY-99 MONDAYErnst 21-MAY-99 TUESDAYMourgos 16-NOV-99 TUESDAY------- ----- SUNDAY Latest Answer : SELECT job, count(*) AS no.ofemployee FROM emp GROUP BY job; ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0