Questions

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 ...

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...

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...

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...

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...

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,...

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 "...

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-...

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...

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...

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...

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. ...

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...

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...

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 ...

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...

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 ...

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 ...

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...

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....