 Related Questions Latest Answer : Of course Varchar2 is there to maintain variable length of columns. It keeps an internal pointer to maintain Variable length that means it wastes two bytes to keep first and last index where column starts and Calculates for each DML operation against ... 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 ... LGWR have to wait because checkpoint not complete so remove this error increase DBWn.Explain how DBWn related to LGWR? 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 Hello, I have problem with this RecordSet. Do not open with "select distinct". Why?Without "distinct" recorset is opened without problems.Private Sub Command1_Click()Dim Cnn As New ADODB.ConnectionDim rs As New ADODB.RecordsetDim CadOracle As StringDim CadSql As StringCadOracle = "DSN=Oracle;UID=RECAUDA;PWD=xxxx;DBQ=orcl"Cnn.Open CadOracleCadSql = "select distinct NOMBRE_MUNI_SUJ from paddgc53"rs.Open CadSql, Cnn, adOpenKeyset, adLockOptimistic, adCmdTextWhile Read Answers (2) | Asked by : boha What is the maximum number of columns in a table in Oracle?What is the maximum number of canvases in What is the maximum number of columns in a table in Oracle?What is the maximum number of canvases in a form in forms 6i an forms 9i? Read Answers (9) | Asked by : sujit murumkar Latest Answer : Oracle is not truly a multidimensional database as Hyperion does.. ... Read Answers (3) | Asked by : Srinu I want to try create the database from my script which i made.can help me how to run a script. can explain me step by step because i am a starter.thank's 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
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
