|
89 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: SQL & PL/SQL «»
Posted on: Wed, 25 March 2009 10:23 «»
By: S.Rajaram
Re: Vertical Pivot query
…this link.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:766825833740
And search for the post dated "Pivoting example using ref cursor December 31, 2003 - 2pm"
I hope it answers your question how to do it.
…
|
9 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 04 March 2009 14:32 «»
By: andrew again
Re: Package inquiry...
…http://asktom.oracle.com/~tkyte/ResultSets/
The examples in the link above all use strong ref cursors. Your need is for weak ref cursors where the number and definition of columns in the resultset is dynamic. The problem is that your client (ASP) needs…
|
10 |
Forum: Forms «»
Posted on: Sun, 15 February 2009 22:54 «»
By: djmartin
Re: Exporting the data from forms 10g to an excel sheet in Symbolic Link (SYLK) format.
…for using Excel through ODBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4406709207206#18830681837358
create excel chart in form6I/How to SetSourceData into excel.chart in form6i
http://www.orafaq.com/forum/t/99738/67467/
Call …
|
11 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 03 February 2009 10:48 «»
By: S.Rajaram
Re: Find string in view Definitition (Merged N times)
See this link and look at the last post.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1191679540050
Regards
Raj
|
12 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 21 January 2009 16:57 «»
By: andrew again
Re: Prasing a text field (merged)
…with this a bit. Tested on 11g, but should work on 9.2.
from asktom.com
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
SQL> variable txt varchar2(1000);
SQL>
SQL> exec :txt := 'BF LOIN NY STYLE SIRLOIN D3400…
|
13 |
Forum: Performance Tuning «»
Posted on: Mon, 29 December 2008 03:42 «»
By: Frank Naude
Re: Thread 1 cannot allocate new log
Yes, that is good advice. You need to add more redo log files or make them bigger.
For more info, see http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:69012348056
|
14 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 17 December 2008 21:02 «»
By: Barbara Boehmer
Re: Need help!!!
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:146412348066
|
15 |
Forum: Forms «»
Posted on: Mon, 15 December 2008 00:48 «»
By: djmartin
Re: import data from excel and process via oracle forms 10g
…for using Excel through ODBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4406709207206#18830681837358
create excel chart in form6I/How to SetSourceData into excel.chart in form6i
http://www.orafaq.com/forum/t/99738/67467/
Call …
|
16 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 24 November 2008 10:57 «»
By: flyboy
Re: PL/SQL Reflection
…described in this thread on AskTom: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:227413938857#2973344838545.
Much more sensible approach would be using more "dynamic" variables, e.g. index-by tables: SQL> set …
|
17 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 08 November 2008 15:35 «»
By: Barbara Boehmer
Re: ERROR - Buffer overflow, limit of 1000000 bytes
Scroll down to workaround 3 for Tom Kyte's my_dmbs_output package in the following thread. It does not have either of the limitations.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:146412348066
|
18 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 10 September 2008 03:03 «»
By: dwarak.k
Re: Delete with commit scope
if you are not deleting all records of the table,
Look here
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2345591157689
Regards,
Dwarak
|
19 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 05 September 2008 18:52 «»
By: Barbara Boehmer
Re: All table_names, row_count and size
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1660875645686
|
20 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 27 August 2008 10:11 «»
By: Barbara Boehmer
Re: UTL_FILE - buffer overflow, limit of 2000 bytes
The following link contains a my_dbms_output package by Tom Kyte that is a workaround for the dbms_output limitation in older versions.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:146412348066
|
21 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 25 August 2008 09:34 «»
By: flyboy
Re: Dynamic PL/SQL
The requirements reminded me this thread: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:227413938857#2973344838545.
But, it would be much easier to create one array variable X and pick the required value by given index.
|
22 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 17 August 2008 20:38 «»
By: BlackSwan
Re: Pack decimal
GOOGLE is your friend but ONLY when you use it!
http://asktom.oracle.com/pls/asktom/f?p=100:11:8319646193033485::::P11_QUESTION_ID:228813971094
|
23 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 08 August 2008 04:34 «»
By: Olivia
Re: CAN YOU HELP ME GET THE LOGIC
…go through the link below.It may be helpful for you.Such kind of query has been asked so many times here. Search by the keyword "pivot"
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:124812348063
Regards,
Oli…
|
24 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 29 July 2008 11:40 «»
By: andrew again
Re: Cursor cache in nested queries ?
See if this is an option for you.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1288401763279
|
25 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 16 July 2008 05:57 «»
By: Anita123
Mutating Trigger
…i followed the following approach.
http://asktom.oracle.com/tkyte/Mutate/index.html
There is still an issue that the earlier values are getting retianed in the array. this is because the triggers are not getting called in a specific pattern , but are …
|
26 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 07 July 2008 14:50 «»
By: andrew again
Re: Dynamic SQL and Unicode
…query to assess the situation.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1163635055580
Your issue may be related to more to what your database characterset and NCHAR characterset is as well as your client environment settings…
|
27 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 27 June 2008 15:00 «»
By: S.Rajaram
Re: Merge - performance issue
…mentioned in this link.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6407993912330
As @Ana already mentioned are you aware of any changes that has happened recently since the last merge completed successfully?
Regards…
|
28 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 18 June 2008 09:40 «»
By: S.Rajaram
Re: More Efficient Top N
Check this link.
http://www.oracle.com/technology/oramag/oracle/07-jan/o17asktom.html
Regards
Raj
|
29 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 09 June 2008 21:40 «»
By: ora1980
find out isolation levels used for my database
…was going through this link
http://www.oracle.com/technology/oramag/oracle/05-nov/o65asktom.html
about isolation levels, and if isolation levels are "used"..then
1)how to find out which isolation level my database follows?
2) once i …
|
30 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 30 May 2008 07:39 «»
By: S.Rajaram
Re: Best way of long to long column insertion in sql
…statements are contradicting each other or am I missing something here.
Have a look at the discussion mentioned in this link.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:839298816582
Regards
Raj
[EDIT:] Link added…
|
31 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 19 May 2008 18:09 «»
By: andrew again
Re: How to put a group of columns from multiple rows into one row dynamically
calm down ana, give the business what they ask for, not what you think they need...
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4144552766253
|
32 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 21 April 2008 04:54 «»
By: S.Rajaram
Re: Need help in copying CLOB data over DBlink
… your text and in the first page i got the clue what I am looking for. So I believe from next time onwards you will try to utilise the search facility.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:52297289480186
Regards
…
|
33 |
Forum: Training & Certification «»
Posted on: Thu, 17 April 2008 18:59 «»
By: Barbara Boehmer
Re: trigger
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:238097000346364720
|
34 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 10 April 2008 09:45 «»
By: S.Rajaram
Re: Most disk space-efficient number type?
…reference manual. It is useful on tables which are only inserted and selected. If you do updates then compress could prove expensive. For more information check the oracle reference manual or asktom.oracle.com.
Hope that helps
Regards
Raj…
|
35 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 02 April 2008 22:03 «»
By: BlackSwan
Re: Cursor Question
…http://asktom.oracle.com contains many fine coding examples
If you can solve the problem using SQL, then use only SQL.
If you can solve the problem using only SQL, then use PL/SQL.
Does GOOGLE search for oracle "bulk collect"
Results 1…
|
36 |
Forum: Forms «»
Posted on: Sun, 30 March 2008 23:50 «»
By: djmartin
Re: How to SetSourceData into excel.chart in form6i
…://www.orafaq.com/forum/t/90502/67467/
To run an excel macro
http://www.orafaq.com/forum/t/47685/67467/
Worked example for using Excel through ODBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4406709207206#18830681837358
…
|
37 |
Forum: Performance Tuning «»
Posted on: Tue, 18 March 2008 16:12 «»
By: Barbara Boehmer
Re: Analytical Functions and Backward Index scans
…can just wait for his response:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:10445280893164#720748100346204751
I noticed you have also asked on a dba forum and I assume other places. Tom Kyte usually gives excellent …
|
38 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 12 March 2008 10:43 «»
By: BlackSwan
Re: Get name of function
does this help?
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1529405950004
|
39 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 07 March 2008 08:03 «»
By: Michel Cadot
Re: Run PL SQL code from external file
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:952229840241
Regards
Michel
|
40 |
Forum: Training & Certification «»
Posted on: Mon, 18 February 2008 02:31 «»
By: Michel Cadot
Re: extents in tablespace
Tom Kyte already answered you to this yesterday:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:670665100346630188
I don't see what we can say more.
Regards
Michel
|