Latest Answer: Sequence is used to generate numbers which can be stored in tables. View does not have data of its own and is generally used to query data. So sequence can not be created to a view. ...
Latest Answer: Oracle is not truly a multidimensional database as Hyperion does.. ...
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 ...
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: 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. ...
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. ...
View page << Previous 1 2 3 [4] 5 Next >>
Go Top
