Skip to Main Content

Questions

QuestionUpdatedAsked

The question I have is regarding the ADD_MONTHS function. The live sql link for the test case is as below:- https://livesql.oracle.com/apex/livesql/s/JT1FDGOHXMRWN3LG94GEYLMPJIf we have a look at this link it has 3 components:- 1. A function that takes an old ...
4 hours ago2.2 years ago

Hi Tom,when we use materalized hint in with clause that data is stored in GTT(Global temporary table). In GTT data is release either when commit happens orwhen session ends.I also read in one of your page that suppose 100 users are using the query that contai...
4 hours ago6 years ago

Hi ,I am new to PLSQL and i am trying to insert data into table using insert into partition (partition_name) . When i am trying to load the data its saying the 'specified partition is not exixisting' . Please help me in this. The query is mentioned belowdeclar...
3 days ago6.7 years ago

some where after OOW, i got this deck "12c_PatternMatching_CON9101_Laker-SQL - the best development language for Big Data.ppt" downloaded, but dont know if it is still available for download.Slide no 43 has an example for SQL Pattern matching example for "Susp...
3 days ago6.5 years ago

I need to perform db operations where I need to inserts .5 million reocrds from another complex query involving joins,exists etc:As of now I am using INSERT INTO SELECT inside a pl/sq package.but some time I am observing for same data set this queries takes mo...
9 days ago3.5 years ago

Hi TomCan you please give an example of using pipelined functions in a *package*. I am not able to make it run within a package. I want to return an array of records from the pipelined function, say likename_1, address_1, city_1, hash value 1name_2, address_2,...
13 days ago20 years ago

Hi Tom !I have 2 databases, A and B. Created a database link from A pointing to B.Let's call it "dblinkB".In database B there's a table "mytable" with a trigger, that captures information from the instance using V$SESSION. I make inserts from A in this table "...
13 days ago3 weeks ago

I have two questions both referring to the documentation in Oracle 19c SQL Language Reference PARALLEL hint "For a statement-level PARALLEL hint" section.https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Comments.html#GUID-D25225CE-2DCE-4D9F-...
2 weeks ago6 weeks ago

Hi,I'm looking for a query to get all objects modified within the last 24 hours. The data dictionary has views like user_objects with usable columns (created, last_ddl_time, timestamp). But there are also views where I didn't find any information when the obje...
2 weeks ago3 weeks ago

Hi Tom,Please clarify the following points:1.what is the difference between local context and global context?2.For a session, can both exists and if yes, what differentiates them?3.I have heard that this concept is basically used for web based application beca...
2 weeks ago15.7 years ago

Hi Tom,on more question :)I´m using the utl_http package to exchange xml-data between different oracle databases.Until now i´ve requested the mod_plsql (until 11g) or the apache (from 12c) on the other database, posted the data with utl_http.write_text and rec...
2 weeks ago4.7 years ago

Hi tom,I want to know how Oracle parse and execute both static and dynamic SQL, can you explain to me ?Is it better to execute stored procedure than to use parse, execute SQL ?Thanks,Julien. ...
2 weeks ago21 years ago

Hi tom,In our oracle database setup frequently getting error like -Fatal NI connect error 12537, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for Linux: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version...
2 weeks ago5.9 years ago

Hi,Business requirement is to generate excel/csv BIP output of concatenated transaction notes (on oracle cloud ERP). The identified source table is ZMM_NOTES, column NOTE_TXT (CLOB data type).Development team is using the listagg() function to concatenate mult...
2 weeks ago3 weeks ago

Hi Experts, Thanks for taking the time out to ready my Question. I am receiving a file from a third party as a flat file, with different lines of different lengths. The first two characters of each line represents what data that line will have. (Please let me ...
2 weeks ago4.6 years ago

Dear Team,May I know how do we determine the below for a string.1. If its numeric.2 . Alphanumeric.3. Hexadecimal (E.g Mac address).RegardsKalyana Chakravarthy...
2 weeks ago6.1 years ago

Hello,We have created the multiple Editions in oracle 19c while dropping the editions using cascade we are getting below error.<code>ora-38810 implementation restriction cannot drop edition that has a parent and a child.</code>Request your help/suggestions to ...
2 weeks ago3 weeks ago

We have below table...<code>boards(account_id number, b_key varchar2(36),status varchar2(2), ....)</code>.This table is range partitioned on account_id. There is composite primary key (account_id, b_key) on this table.When we are executing query on this table ...
2 weeks ago3 months ago

Hello gurus,I have a problem with bind variables in 19c.<code>SQL> set feedback on sql_idSQL> VARIABLE DPT_ID01 NUMBER;SQL> VARIABLE DPT_ID02 NUMBER;SQL> EXEC :DPT_ID01 := 50;SQL> EXEC :DPT_ID02 := 80;SQL> select D.DEPARTMENT_NAME, E.DEPARTMENT_ID, E.FIRST_NAM...
2 weeks ago3 weeks ago

we have a following definitionTYPE response_t IS RECORD ( doc XMLTYPE );A local variable is defined with that record typelv_resp response_t;I want to print the value this local variable has stored.I tried dbms_output but dint work....
2 weeks ago3.4 years ago