Skip to Main Content

Questions

QuestionUpdatedAsked

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...
37 hours 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...
37 hours 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...
8 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,...
11 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 "...
11 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-...
12 days 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...
12 days 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...
12 days 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...
12 days 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. ...
12 days 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...
12 days 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

Dear Experts,Please can you help in knowing how to find for top 10 queries/sessions generating huge redo.I tried with the below queries to check redo generated per day, but not able to find top 10 such sessions which generates so.select trunc(completion_time) ...
2 weeks ago4.8 years ago

Tom:when i query v$session_longops, i got the following result:select username ,sid,serial# from v$session_longops;SYS 12 1 John 28 438 HP_DBSPI 42 39 HP_DBSPI 42 39 HP_DBSPI 40 ...
2 weeks ago21.6 years ago