Skip to Main Content

Questions

QuestionUpdatedAsked

Hi AllIt's my first question here :)I read about formatting number in scientific notation, but I don't find a way to group exponent by 3For instance, I would have this result Number -> result1 -> 001.0E012 -> 012.0E0123 ...
32 hours ago2 days ago

Hi Tom,When i try to insert huge data into a CLOB colum, i get "PLS-00172: string literal too long". Tried searching in web/metalink, but of no use. Please let me know if a workaround is available for this insert.drop table t9;create table t9(template clob);cr...
34 hours ago15.4 years ago

Dear Tom,As User System connected I want to query a V$ table in a view. When creating the view I get the error ORA-00942: table or view does not exist.Example:<code>create or replace view myview_datafile as select file#, bytes/1024/1024||' MB' as "SIZE" from V...
46 hours ago2 days ago

I need to have current cursor position in TinyMCE Oracle Apex. I use this js code for another type of page items and it work correctly.var curPos = document.getElementById("P7_TEXT").selectionStart;but when "P7_TEXT" is a Rich Text Editor (TinyMCE) , it will r...
46 hours ago4 weeks ago

Dear Team,I hope this message finds you well. I have been reflecting on the current landscape of PL/SQL and its role in contemporary technology stacks. I would greatly appreciate your insights on a few points that have been on my mind.<b>PLSQL for Business Log...
2 days ago3 weeks ago

I'm using Apex 23.1 and I want to add a new font family in Tiny MCE with url file reference ! here's what I've done :1- in Initialization JavaScript Function section<code>tinymce.init({ /* ... */ font_formats: "Andale Mono=andale mono,times; Arial=arial,helv...
2 days ago5 months ago

first run the command startup nomount, done, then run the query, alter database mount, done, also open the control files, then run the query as:ALTER DATABASE OPEN, gives the following issue as:SQL> alter database open;alter database open*ERROR at line 1:ORA-0...
2 days ago7 years ago

Hi Tom.I'm a great believer that a backup you haven't tested isn't a backup, so I'm trying to ensure that our RMAN backups get automatically verified, however I've come across some weird behaviour with rman backup validation.My aim is to run full verification ...
2 days ago6 weeks ago

Hi Tom,I'm facing an issue somewhat strange and to which a have no clear answer.The database version that I'm using is 12.1.0.1.0 on Windows 64 (both Standard and EE).With 11G (I believe) Oracle started using the Unified Audit Trail. The default "rules" for my...
3 days ago7.8 years ago

I like your classification of hints into good and bad hints and try to follow it.Today, I learnt about the opt_param hint, which is undocumented in 10, but documented in 11.I encountered a situation, where optimizer_index_caching was set to the non-default-va...
3 days ago15.7 years ago

I wanted to extract all the numbers from this string '12gfsda@3fg,f' and want to display.Like for example i want 123 to be extracted from 12gfsda@3fg,f and display only 123....
3 days ago6.5 years ago

Tom,I got the following statements from v$sql* .What does it imply when the parsion_shema/user_id is 0 (SYS)?. In the v$sql_shared_cursor I see the only difference is in BIND_MISMATCH. Is it the cause for 16 occurences of the same sql, in the v$sql?If the sql ...
4 days ago20.8 years ago

Hello Connor/Chris,I am in the middle of troubleshooting a slow-running application maintenance job for a database that has been migrated/upgraded from on-premise 12.1.0.2 on linux x64 to Exadata Cloud @ Customer setup. Many of the "Top SQLs" that have regress...
7 days ago4 months ago

I have a package working fine in 11g version.But when I deploy the same package in 19c version, the behavior is different.PFB the description.Package specification has an cursor and created a table type with cursor%rowtype. Having a pipelined function which re...
7 days ago4 years ago

During the installation of some application software, we build the necessary schema objects in Oracle if they don't exist. Additionally, we point out any potential problems to the user doing the install. Some of these problems vary with the Oracle server platf...
7 days ago22.1 years ago

Hello Tom,Could you please advise why I'm getting so huge difference in db block gets and redo for insert between range and reference partitioned table?Db block gets are like 100x more for reference partitioned table and insert is 2-3 times slower.<code>DB01> ...
9 days ago4 weeks ago

I have a problem with how SQL loader manage the end of a column value. I was hoping to manage CR LF, the enclosement character and the separator character but it seems I can't find a solution!The data I receive from the .csv file looks like this:<code>"C","I",...
11 days ago3.4 years ago

Hi, Tom,How are you.I have below source code:create or replace and compile java source named "Something" asimport oracle.sql.*;public class Something { ...............}When i wrote above java source file under SQLPLUS, I got the following errors:ERROR at lin...
2 weeks ago22.7 years ago

Hi Tom,Here are the few questions on Locking. 1)How do I use v$lock to figure out lock details ? Details likewhos has locked,on which table,who else is waiting, and what typeof locking (shared or exlusive ?), since when it is locked.2)Why and when exclusive/sh...
2 weeks ago22.7 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...
2 weeks ago7.7 years ago