 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 ... 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 There are how many maximum no of colimns in atable in oracle?There are how many maximum no of canvases in a form in forms6i an forms9i?please will u tell me...tahnking YouSujit Read Answers (8) | 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 Latest Answer : One time procedure, Its actually not a procedure but its called as one time procedure, Why because this used to initialize variable, calling function or procedure once the scope of package for user session.This can be defined like this..Package Body Aa ... Latest Answer : To execute sqlplus via Unix shell scripts the following parameters need to be initialized.(1.) ORACLE_HOME export ORACLE_HOME=Path to (2.) ORACLE_SIDexport ORACLE_SID=Actual ORACLE_SIDAfter these initializations have been done use sqlplus ... Latest Answer : 1. Procedure Overloading and Function Overloading Possible in Package. This Overloading Concept Not Possible in Procedure.2. Variables in Package we Can use as a Global Variables. it's Not Possible in Procedure. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
1