Feed aggregator

TNS error about 'TNS-12535 and TNS-00505' in alert log file of my Oracle 11.2.0.4.0 ?

AskTom - Hot Questions - Thu, 09/21/2017 - 00:00
Hi,teams I found that there has a plenty of TNS error about 'TNS-12535 and TNS-00505' in alert log file of my Oracle 11.2.0.4.0. part content as follows, <code> ...... *********************************************************************** Fata...

extract numbers from varchar2 upto first occurrence of a non-numeric value

AskTom - Hot Questions - Thu, 09/21/2017 - 00:00
On Oracle12 database, we have this table tbl_house_number that has one column "house_number" which is a varchar2 and has data entries of all different combinations. And all I need is the numbers from left to the first occurrence of a non-numeric li...

How you manage you're work-spaces!!

AskTom - Hot Questions - Tue, 09/19/2017 - 00:00
Greetings Team, I am very curious to know how you actually manage you're work spaces.I mean you always face different kind of questions all day along.How many laptops you use(of course you are using VM). But my question is if you guide someone fo...

need to extract numbers from a varchar upto a non-numeric character

AskTom - Hot Questions - Tue, 09/19/2017 - 00:00
Hi, I have a column called house number which is a varchar2, and it has all kinds of combinations of data entered (incorrect format) as shown below: House_Number ------------- 416-A 416-A 1573A 131# A23 133 A-21 133 A22 13320A 133A-21 1...

Flashlogs not getting deleted

AskTom - Hot Questions - Sat, 09/16/2017 - 00:00
Hi Tom, I see FRA size is Filling up and when checked Flashback Logs are occupying most of it as seen below, SQL> select * from v$recovery_area_usage; FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES -------...

Need to generate the output in incremental loops

AskTom - Hot Questions - Fri, 09/08/2017 - 00:00
Hi Tom, I have a query which returns the below output. ONE TWO THREE I need to get the out as ONE ONE TWO ONE TWO THREE ONE TWO THREE FOUR i.e like incremental sets (by step 1). ONE ONE TWO ONE TWO THREE ONE ...

Standby Redo Logs Required For All Protection Modes ?

AskTom - Hot Questions - Fri, 09/01/2017 - 00:00
Hi TOM, Why do we need standby redo logs on standby database when the protection mode is MAX PERFORMANCE? Oracle documentation (http://docs.oracle.com/database/121/DGBKR/dbresource.htm#DGBKR270) says : "You must add standby redo log files on a...

Tuning Question

AskTom - Hot Questions - Wed, 08/30/2017 - 00:00
Hi I have the following query: <code> SELECT cust_id, cosmos_cust_id, prot_id, customer_name, protocol_name, dist_order_no, cust_ivr_ref_no, ship...

JSON object access using JSON_TABLE

AskTom - Hot Questions - Sun, 08/27/2017 - 00:00
Hi I have a JSON object containing complex MVA, and would like to have relational access to my JSON object using JSON_TABLE + View. The way I am doing it right now, gives me 4 rows when I query the View, and I would like the SQL to return two r...

Pages