Latest Answer: below is an eg showing the difference SQL> select replace('missisippi','is','12') replace, translate('missisippi','is','12') translate from dual;REPLACE ...
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
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
Latest Answer: 1. VARCHAR is going to be replaced by VARCHAR2 in next version. So, Oracle suggests the use VARCHAR2 instead of VARCHAR while declaring datatype.2. VARCHAR can store up to 2000 bytes of characters while VARCHAR2 can store up ...
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.
LGWR have to wait because checkpoint not complete so remove this error increase DBWn.Explain how DBWn related to LGWR?
Latest Answer: We can add a signature to a database by using LONG datatype.and can use in the report as required. ...
Latest Answer: SGA: System Global Area. Its a chuck of memory used on oracle processes. ...
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. ...
Latest Answer: Pro*C is an embedded SQL statements. in a high level source program.OCI--Oracle call Interface ...
View page << Previous 1 2 3 [4] 5 Next >>
Go Top
