| |
1895 Search Results Found |
| 1 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 28 August 2023 13:31 «»
By: mathguy
Re: Jaro-Winkler similarity for 9i
…of Jaro-Winkler? in this thread: https://asktom.oracle.com/pls/apex/asktom.search?tag=performace-issue-with-sql-in-the-view-using-utl-matchjaro-winkler-similarity& ;p_session=9590653204898
At least some if not all of the discrepancies you saw …
|
| 2 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 05 March 2014 02:59 «»
By: Michel Cadot
Re: PlSql open read cell in excel file!!
…has been described by Tak Tang at http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4406709207206#18830681837358
Edit: now it is https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:4406709207206#18830681837358…
|
| 3 |
Forum: Server Administration «»
Posted on: Fri, 24 May 2024 01:57 «»
By: Michel Cadot
Re: How to know if my oracle DB is on premise or cloud
… some answers from Connor McDonald:
https://asktom.oracle.com/ords/asktom.search?tag=how-to-know-if-my-oracle-db-is-on-premise-or-cloud
The following page from Sinan Petrus Toma gives a more complete answer:
https://database-heartbeat.com/2021/08/31/…
|
| 4 |
Forum: Server Administration «»
Posted on: Sat, 23 July 2022 15:35 «»
By: Andrey_R
Re: Parse statistic values don't seem to add up
… I found the answer here https://asktom.oracle.com/pls/apex/asktom.search?tag=what-is-an-absence-of-parse and here https://docs.oracle.com/cd/B10500_01/java.920/a96654/stmtcach.htm
I'll follow up in case I have further questions. …
|
| 5 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 02 September 2023 14:02 «»
By: Barbara Boehmer
Re: Jaro-Winkler similarity for 9i
…mathguy,
I stumbled upon the following that I think you will find interesting and may shed some light on the discrepancies between Oracle's function and the standard definition that seem like they might be bugs.
https://docs.oracle.com/cd/E19182-01/…
|
| 6 |
Forum: Performance Tuning «»
Posted on: Sun, 14 May 2023 15:10 «»
By: Barbara Boehmer
Re: Bind by position
Here is another interesting link that demonstrates how execute immediate binds by position and dbms_sql binds by name.
https://asktom.oracle.com/pls/apex/asktom.search?tag=dbms-sqlbind-variable
|
| 7 |
Forum: Server Administration «»
Posted on: Fri, 24 May 2024 10:46 «»
By: John Watson
Re: How to know if my oracle DB is on premise or cloud
…problem with the AskTOM answer is that it doesn't answer the question. It tells you if you are an Autonomous database, it doesn't help if you are (for example) an OCI DB System database.
There must be a way. Oracle himself certainly detects it is a …
|
| 8 |
Forum: Forms «»
Posted on: Thu, 29 October 2020 17:41 «»
By: Amine
Re: master detail problem
You need this : update cascade.
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:31812348052
Follow the comments at the end.
|
| 9 |
Forum: Server Administration «»
Posted on: Tue, 27 October 2020 08:21 «»
By: Michel Cadot
Re: Did I set up UTL_MAIL correctly and completely?
…to use UTL_SMTP as explained in https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:12526941604660#51890874357845
For your posts, better use SQL*Plus and show us (copying and pasting) what you do and get instead of trying to tell us, …
|
| 10 |
Forum: Server Administration «»
Posted on: Mon, 31 August 2020 08:41 «»
By: Andrey_R
UPDATE taking a long time, indication disappeared
…same 4 hours?
Tom Kyte said in https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:698257800346953357- rolling back will take same time, if not more, then the original DML.
But on the other hand - I don't see the transaction anywhere…
|
| 11 |
Forum: Server Administration «»
Posted on: Mon, 18 November 2019 07:59 «»
By: BlackSwan
Re: Plenty of UNDO but keep getting ORA-01555
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:275215756923
|
| 12 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 06 July 2019 03:06 «»
By: sss111ind
Re: Automatic abropting the long running job
…a lot to all and asktom team.
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9536221800346281378
BEGIN
--creating orignial job
dbms_scheduler.create_job('DATA_PULL_JOB',
job_type => 'PLSQL_BLOCK',
…
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 22 April 2019 20:48 «»
By: flyboy
Re: pl/sql procedure compile error PLS-00103
…= 'READ_ONLY';
If you do not have to those DBA dictionary views, just GRANT the SELECT privilege on them directly. You may find its justification in this AskTom thread: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1065832643319…
|
| 14 |
Forum: Server Administration «»
Posted on: Sun, 13 January 2019 11:32 «»
By: Andrey_R
Re: Find out which blocks included in which extent/datafile
… query from AskTom => https://asktom.oracle.com/pls/apex/f%3Fp%3D100:11:0::::P11_QUESTION_ID:466020333473 )
select a.tablespace_name, a.file_id, a.block_id, a.blocks, b.block_id
SQL> 2 from dba_free_space a, dba_free_space b…
|
| 15 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 27 November 2018 22:23 «»
By: BlackSwan
Re: Charater set
https://asktom.oracle.com/pls/apex/f?p=100:11:::NO::P11_QUESTION_ID:9532776700346468197
|
| 16 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 09 November 2018 08:21 «»
By: BlackSwan
Re: How to use Optimistic locking in my Package
…ot; would solve for you?
I do not know what answer you desire?
Other sessions won't see DML changes made by UPDATE statement until after COMMIT has been executed.
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5771117722373…
|
| 17 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 28 September 2018 04:59 «»
By: myclassic
Re: Query for Matching Record --> as much matches
…in order by clause:
https://asktom.oracle.com/pls/apex/f?p=100:11:::NO::P11_QUESTION_ID:9538922100346943929
select * from (
select * from services
where ( srvc = 'srv1' or srvc is null )
and ( location = 'home' or location …
|
| 18 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 20 August 2018 06:30 «»
By: Roachcoach
Re: Row Movement disabled in Partitioned table
The rationale behind migrating is/was https://asktom.oracle.com/pls/apex/asktom.search?tag=row-migration
At least the last I heard.
|
| 19 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 09 June 2018 00:05 «»
By: Michel Cadot
Re: Fetching Unix Folder Name and Timestamp in SQL/PLSQL
…
https://asktom.oracle.com/pls/asktom/asktom.search?tag=plsql-code-to-search-and-find-pdf-from-folder-and-send-in-email-as-attachment
https://asktom.oracle.com/pls/asktom/asktom.search?tag=external-table-preprocessing
http://www.oracle-developer.net/…
|
| 20 |
Forum: Forms «»
Posted on: Wed, 11 April 2018 17:02 «»
By: Barbara Boehmer
Re: Inserting & Retrieving BLOB using Form 6i
Please try the links below.
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:239814548726
https://asktom.oracle.com/pls/asktom/asktom.search?tag=how-to-store-images-into-the-database-through-forms
|
| 21 |
Forum: Forms «»
Posted on: Wed, 04 April 2018 03:19 «»
By: syedferhat
Re: Inserting & Retrieving BLOB using Form 6i
Dear following link is given in your post not available
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:239814548726
|
| 22 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 02 December 2017 11:32 «»
By: Barbara Boehmer
Re: Term Match with Jaro-Winkler logic
…a reference to another link:
https://asktom.oracle.com/pls/asktom/asktom.search?tag=soundex-searches#10577325169281
It might also help, if you would state here what your ultimate goal is, as there may be a simpler solution, perhaps involving Oracle …
|
| 23 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 06 November 2017 11:01 «»
By: BlackSwan
Re: Order of Trigger Types
…https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2575882200346616184
http://www.oracle.com/technetwork/testcontent/o58asktom-101055.html
http://rwijk.blogspot.com/2007/09/database-triggers-are-evil.html
https://stackoverflow.com/…
|
| 24 |
Forum: Performance Tuning «»
Posted on: Wed, 20 September 2017 13:41 «»
By: jokrasa
How to partition unpartitioned existing table
…I see here ( see link below )
https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9533887100346178338
we see
QL> ALTER TABLE a MODIFY
2 PARTITION BY RANGE(x) INTERVAL (10)
3 ( PARTITION P1 VALUES LESS THAN (10),
4…
|
| 25 |
Forum: Performance Tuning «»
Posted on: Mon, 28 August 2017 01:46 «»
By: juniordbanewbie
Can we delete specific execution plan in the db buffer for a statement
…from the database cache.
from https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:4092356300346664639
alter system flush buffer_cache;
SQL> alter system flush shared_pool;
alter system flush shared_pool;
the above flushes…
|
| 26 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 31 July 2017 02:05 «»
By: flyboy
Re: Regular Expression : Find and Replace Specific String
…perform on that data?
Just for completeness, here is an example of PRINT_TABLE function doing just that (store it into DBMS_OUTPUT buffer) in this AskTom thread: http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1035431863958
Good luck…
|
| 27 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 24 July 2017 08:15 «»
By: Bill B
Re: Ref cursor results to CSV?
… supplied query. See the following link. The name of the utility is DUMP_CSV
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:68212348056
cut and compile the code in the body of the message. I have used it and it works just fine…
|
| 28 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 15 June 2017 00:26 «»
By: flyboy
Re: Help the newbie to do my first procedure
…only one row.
Think in sets: https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:8744181900346696062
Additionally, SQL is not a procedural language, but rather a declarative one. You do not state HOW the result shall be achieved, but WHAT…
|
| 29 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 31 May 2017 09:59 «»
By: Bill B
Re: oracle external table issue
…can. In your routine you can simply get a current file list and use an execute immediate to do an alter command like cookiemonster suggested and read in your table
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:439619916584…
|
| 30 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 May 2017 08:56 «»
By: flyboy
Re: dbms_output.put_line for dynamic sql query
…function in this AskTom thread: http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1035431863958
Also, beware the correctness of the constructed SQL statement (you have inspected it, have not you?) - the ending comma in V_COL the will …
|
| 31 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 16 May 2017 15:59 «»
By: BlackSwan
Re: Use ":NEW" in Dynamic SQL in Trigger?
… REALLY trying to solve?
http://www.oracle.com/technetwork/testcontent/o58asktom-101055.html
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2575882200346616184
http://rwijk.blogspot.com/2007/09/database-triggers-are-evil.html…
|
| 32 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 11 May 2017 22:37 «»
By: jen888
Re: Pass two or more value
…see the hard code, and I have four parameters.
I search for the "varying elements in IN list" and find Tom's post as:
https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:110612348061
It doesn't work either.
Thanks…
|
| 33 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 20 April 2017 21:56 «»
By: pointers
DEFINE_COLUMN in DBMS_SQL
…used in the *output*
Source: https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9526411800346939330
But, DEFINING a Column as DATE of a VARCHAR2 column would anyway throw an error.
Converting a NUMBER to VARCHAR2 anyway happens …
|
| 34 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 13 March 2017 06:23 «»
By: cookiemonster
Re: How to find highest salary ?
…; 1 could never ever be true. You don't get row zero.
That said, what you probably meant to code:
rownum > 1 and rownum < 3
will never work either, see this for why:
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:76812348057…
|
| 35 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 10 March 2017 23:46 «»
By: annu-agi
Re: function based index on date column
…ON DATE COLUMNS ..."
https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9531667400346397777
https://hoopercharles.wordpress.com/2010/03/08/impact-of-the-trunc-function-on-an-indexed-date-column/
http://www.dba-oracle.com/…
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 15 February 2017 14:11 «»
By: BlackSwan
Re: Oracle BLOB DATA
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:696224943687
|
| 37 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 31 January 2017 02:34 «»
By: rzkhan
Re: constraint error
…E');
1 row created.
SAM@orcl:>
Thanks a lot for all your help. GREAT !!!!
priceless knowledge. I should read in detail constraints vs indexes
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:3051352977204…
|
| 38 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 21 January 2017 01:16 «»
By: Michel Cadot
Re: How to create an object table
…e41084/statements_7002.htm
what you posted is an Entityattributevalue table.
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2314483800346542969
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:26200054737635…
|
| 39 |
Forum: Server Administration «»
Posted on: Thu, 08 December 2016 04:10 «»
By: juniordbanewbie
Is there a optimal size for file next extent size?
… size for next extent value?
from https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1960884062300
while I totally agree with the guru, Tom Kyte on file next extent size should be a multiple of my extent size, I do not know why he …
|
| 40 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 02 June 2016 13:49 «»
By: Bill B
Re: transpose and insert the data
see the following article
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4471013000346257238
|
Blog
Search
Help
Members
Register
Login
Home