Skip to Main Content

Questions

QuestionUpdatedAsked

Can you give me a solution for converting CLOBS datatype to VARCHAR datatypes, all the documents I refer to talk about converting BLOBS to VARCHAR and when I try and apply the examples to CLOBS, get errors ...
53 minutes ago21.4 years ago

Are analytical functions replacement for aggregate functions? Some of the developers here are hurrying in replacing the group by aggregate functions with analytical functions just because they learnt something new :-).. Are the analytical functions faster alwa...
62 minutes ago15.8 years ago

Hi,I checked EXPLAIN PLAN of a Select Query(In SQL Devloper Tool by pressing F10 Short cut Key), there i noticed one column Cardinality with COST.As Cardinality Increases i noticed increase in COST, i read Optimizer chooses less cost plan to Execute the Querie...
64 minutes ago5.4 years ago

Hi Tom,I have a task to migrate data from 4 hierarchical tables into few hundred flattened tables. I have developed some options but am looking for possible improvements or more effective ways.So I have 4 tables let's say:create table t1(id number, name varcha...
66 minutes ago6.7 years ago

Hi Tom,I am working on an 11g database and writing a PL/SQL application that moves partitions from the active schema to an historical schema. In one instance, I have a RANGE partitioned table with two "child" REFERENCE partitioned tables. Since I'm not in 12c,...
66 minutes ago6.3 years ago

I have a PL/SQL package and want to find that package's code coverage. I am using the DBMS_PLSQL_CODE_COVERAGE utility. I can get the code coverage for the whole PL/SQL package. But I want to get the coverage at the Function/Procedure level.The coverage tables...
16 hours ago26 hours ago

connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist...
18 hours ago5.9 years ago

Hello,I inherited from a schema that is using nvarchar2.I am trying to recreate that schema but I am struggling to create table with nvarchar2 that have a size of 4000 (> 2000).I have changed the max_string_size to "extended" but it does not works. I works var...
26 hours ago5 days ago

Hello.I have a win 2012-R2 server in which I have installed Oracle DB- 11G & 12c in separate homes.I contemplated on having multiple listeners for each install but was advised against it in the forums.My lsnr service for 12c is set as the main service to handl...
26 hours ago6.4 years ago

hi tomi have a databse with 125 tables. i can find the total number of tables of the database by the sql select * from tab; now i would like to know the number of rows in each table of my database with out executing select count(*) from...; each time.please...
26 hours ago20.8 years ago

Hello,We have issue since we have moved from entity framework 6 on .net 48 to entity framework core on net 6.The thing is, that after any kind of application termination, there are processes left open, alongside sessions, which result slowly creeping up to lim...
26 hours ago4 weeks ago

Hello,I have a table that I want to update with spatial relationship.My query is as follows;UPDATE PARSEL P SET P.ILCE_ID= (SELECT G.OBJECTID FROM GEOILCELER G WHERESDO_RELATE(P.POLY, G.GEOM , 'mask=OVERLAPBDYINTERSECT')= 'TRUE' AND(P.UPSERT_INSERT =1 OR P.UPS...
28 hours ago46 hours ago

We have a query against a view in production which used to run efficiently. However, recent explain plan showed some full table scan in one table which proper index and join with other table in the view.We indexed the table but it does not seem to fix the issu...
28 hours ago2 days ago

Hi Ask Tom Team,Recently I came across MATCH_RECOGNIZE clause. I checked the Oracle documentation but it's not easy to digest.Looking at OLL webinars, youtube videos and some of Ketih's article on oracle blog helped me understanding a little of it.In oracle tr...
40 hours ago5.5 years ago

Hi Tom,What plan do you suggest to purge a table which is of size 377Gb approx?We are currently following this plan,- Creating a temporary table with the required data(Approx 86 crore records).- Drop the constraints(15 constraints).- Truncate the original tabl...
40 hours ago2 days ago

Haai..i have input like this in below..<code>Create table Char(name varchar2(1000));Insert all into Char(name) Values('Ask Tom')into Char(name) Values('Become Again Tom')into Char(name) Values('United Sates')select * from dual;NameAsk TomBecome Again TomUnited...
41 hours ago3.8 years ago

Why is writing to Redolog file is faster then actually writing changes to datafiles ?...
2 days ago5.3 years ago

Why are you talking about the license, there is a license to have the software?...
2 days ago3.5 years ago

Tom, sorry about the silly question, but have been trying to do something with SQL Model without any success. I cannot understand how it works, could you do some simple sample? -- may be already exists.Thanks, ...
2 days ago18 years ago

Hi Tom,I have a table as follows:SQL> desc t; Name Null? Type ----------------------------------------------------- -------- --------------- NAME VARC...
2 days ago20.1 years ago