Skip to Main Content

Questions

QuestionUpdatedAsked

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...
2 days ago12.7 years ago

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...
2 days ago2 years ago

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...
4 days ago2 weeks ago

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 ...
4 days ago2 weeks ago

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 ...
4 days ago5.1 years ago

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

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... ...
4 days ago14.7 years ago

Why are you talking about the license, there is a license to have the software?...
4 days ago2.4 years ago

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. ...
5 days ago19.1 years ago

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...
6 days ago9 days ago

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

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...
6 days ago4.3 years ago

<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,'...
6 days ago3.9 years ago

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...
9 days ago10 days ago

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...
9 days ago10 days ago

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...
9 days ago10 days ago

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...
9 days ago10 days ago

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...
10 days ago10 days ago

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...
10 days ago10 days ago

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?...
10 days ago2 weeks ago