Skip to Main Content

Questions

QuestionUpdatedAsked

Hi Gurus,The schema is provided in the LiveSQL Link.Employees of each department have to make two (02) propositions (prop1 and prop2) among four (04).So prop1 and prop2 go from 1 to 4.prop2 is optional.The decided column is the decision of the HR department. W...
21 hours ago10 days ago

Why does the Oracle SQL Optimizer include a filter predicate for a Check Constraint when generating an execution plan for a SELECT statement? If the constraint is valid (according to DBA_CONSTRAINTS), then the table rows are all compliant with the constraint, ...
24 hours ago1.6 years ago

The APEX QuickSQL utility has the "Tags Framework" flag. Anyone has a detailed explanation about when and how to use it?...
31 hours ago9 days ago

while Creating a Physical standby database using duplicate Database command on the Physical Standby machine, getting the following error:Creating the Standby Database1. Start up the standby instance# in srv2:su - oracleexport ORACLE_SID=ORADB_S2# now start up ...
31 hours ago9 days ago

Hi Tom, I have a problem followingI have 2 database at 2 different site and my job is transfer user a scheduler job at site B, pulling data from site A via dblink_b2a. about 14m records/daywhen I execute single statement:<code> insert /*+ append */ into tab...
31 hours ago10 days ago

Good Afternoon Gentlemen,I really need clarification on setting up SSL encryption for data packet encryption as it driving me a bit crazy. I want to setup SSL encryption to make sure that data packets that is set to and from the client and oracle database is ...
31 hours ago12 days ago

Hi Chris/Connor. We have a production 12c Database (12.2.0.1) and have enabled a particular SQL Plan Baseline for a high-load query, but, for some reason, it's not being used. Baseline is ENABLED and FIXED, and REPRODUCED column reads YES, but I can't see a da...
31 hours ago12 days ago

Hello sir, I have the following list of alphanumeric and numeric values-12345101112221112221111SM-AHR18PNL18186 1of 3PNL18186 2 of 3PNL18186 3 of 3T1GC042TLR10C3AKBA41901108 1 of 1J0501B-T0516T 1 of 11ABC22ABC111ABC22ABC I am able to sort all numeric values us...
32 hours ago5.7 years ago

We perform a duplicate database from prod to test weekly and have a script that captures the current user permissions on dev via the dbms.metadata.get_ddl package that generates DDL to another file to be used after the duplication to re-create any user that ha...
32 hours ago3.4 years ago

Hi TomI would like to ask a Question about Bitmap indexes, somethings in this indexes is still unclear for me.Many rumors revolves around what exactly gets locked (and how) during a DML operation on column\row with Bitmap index, it starts with a full exclusive...
32 hours ago13.5 years ago

TomThese days Iam facing a huge problem which is wasting a lot of mytime.I have this table t , which has a million records.For my work, I need to keep checking the number of total records , many number of times in a day.when I do a select count(*) the sqlplus ...
32 hours ago19.9 years ago

HI,I created a bat file to run sqlldr to load the data from a csv file into Oracle,and I want to execute it automatically ,so I tried it by DBMS_SCHEDULERexec DBMS_SCHEDULER.run_job('DAILY_LOAD');Rapport d'erreur -ORA-27369: ├ęchec du travail de type EXECUTABLE...
32 hours ago3.8 years ago

When I query a database that includes a particular field (Condition), it returns multiple rows of Conditions associated with the same result from another column (NCT_ID). See sample output below. NCT_ID CONDITION NCT00531284 Multiple MyelomaNCT0...
32 hours ago8.7 years ago

Dear Tom,I am really happy that I got this opportunity to put the 2nd question to you.We have a requirement to have a Global Temporary Table with a CLOB column. As per the Oracle Documentation, the CLOB segment will sit on the system tablespace and so it does....
32 hours ago15 years 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 ...
32 hours ago5.1 years ago

Hello,I'm building a function that always receives 3 input values. These incoming values are used as bind variables in assembling a SQL query string that is later executed using an EXECUTE IMMEDIATE statement.The SQL query string contains a SELECT INTO stateme...
44 hours ago4.1 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. ...
45 hours ago19.2 years ago

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