Questions

Hi Tom,When i try to insert huge data into a CLOB colum, i get "PLS-00172: string literal too long". Tried searching in web/metalink, but of no use. Please let me know if a workaround is available for this insert.drop table t9;create table t9(template clob);cr...

I have table which contains millions of rows.I want to delete all the data which is over a week old based on the value of column last_updated.so here are my two queries,Approach 1:<code>Delete from A where to_date(last_updated,''yyyy-mm-dd'')< sysdate-7;</code...

Hello Team,Thanks for all the good work AskTOM is doing.Can you please help us to better understand about max_sessions, max_task_threads and max_dispatchers configuration parameters of MultiThreaded ExtProc agent and share tips on how to determine optimum valu...

Hi TOM, I am facing an issue with flashback versions query. I have described my issue below.<code>Query 1: select versions_xid XID, versions_startscn START_SCN, versions_endscn END_SCN from employees ...

Hi,Am using CLOB data type in stored procedure. I am appending data from temporary table in CLOBI have a following plsql.DECLARETYPE sturecord IS RECORD (stid NUMBER, Regid NUMBER); TYPE stutype IS TABLE OF sturecord; stutable ...

How to send personalized email to clients registered in my portal www.intrainternet.com using the information stored in our Database Oracle 8i automatically? ...

HI Tom, I am running one procedure using dbms_job.submit. but it is getting failed immediately. i wrote dbms_output command to output the error message. So how and where can I see that error message.Thanks in advance for your great support... ...

Why are you talking about the license, there is a license to have the software?...

How can I can set a package function to be deterministic? It is easy forstandalone function, but I couldn`t find the right syntax for package functions. ...

Hi Tom,The web app we have uses java class to call stored procedures. User inputs are used to pass parameter values while calling the stored procedure. Is there a way in oracle that I get to know what parameter values are passed by querying some dbms table or...

Source table :<code>----------------------------------------| Employee Name | department | Emp Id |----------------------------------------| Sam | Sales | 101 |----------------------------------------| Sam | Finance | 101 ...

I have one more requirement where I need to change one particular user's password belongs to an application which is hosted outside of our network.External application team provided information about REST API that need to used to search user and change passwor...

<code>create table ticket1(ticketid number, tcktname varchar2(10), status varchar2(10) );INSERT INTO ticket1 VALUES (101,'bug','open');INSERT INTO ticket1 VALUES (102,'bug','close');INSERT INTO ticket1 VALUES (103,'...

I have two tablespaces named USERS and INDX, respectively. The dufault tablespace for current user is USERS. I created an IOT table whose name is tb_zxp. Since no need to specify a tablespace storing data for IOT, I'd like to put the whole index of tb_zxp on t...

Hi guys.I have a piece of code like this:<code>declare myvar number := 4; begin select rule into v_stmt from rules where rule_id=1; --v_stmt -> 'begin :a := my_function(my_var, 1), 1); end;' execute immediate v_stmt;end;/</code>Is there a way to inject m...

How to load using Oracle SQL Loader values to it's related detail rows if the file has multiple headers and details rows. The issue is header row attribute cannot be applied to it's related detail rows in event of multiple header/detail transactions. It does w...

Hi Tom,I have a table like below:<code>GRP,SUBGRP,START_Y,END_Y122,...123,A,2010,2011123,A,2011,2012123,A,2012,2013123,A,2013,2014123,B,2014,2015123,B,2015,2016123,B,2016,2017123,A,2017,2018123,A,2018,2019123,A,2019,2020124,...</code>I would like to find start...

Want to insert data in TIMESTAMP column having year less than 4713 i.e. timestamp like '01/01/8999 BC'so here year is -8999 When I tries to insert it gives me error like 'YEar should be between -4713 and 9999'.BUt for some table I am having year less than 471...

I have tried altering the start with value of an Oracle sequence but I face [<b>ORA-02283: cannot alter starting sequence number</b>] error.I tried to find why Oracle does not allow the same but I could not find an appropriate answer for that.So my question is...

Hi,I'm using oracle 10.2.0.1 for studing, and I queried the v$session using pl/sql developer from a windows pc client ,but I found the garbled code from the results.just as following:<code>SQL> select osuser from v$session; OSUSER--------SYSTEM????SYSTEMabc?...