Skip to Main Content

Ask The Oracle Masters

Recently Answered

Recently Answered Report

Chris SaxonFilters order in SQL query
Hello, Ask Tom Team.I want to know to put the correct order in the filter in a SQL query. I mean, in the WHERE condition. 1. How can we help the optimizer in order to have the best performance? I know that it tries to execute the best plan based on the statist...
Language of APEX Office Hours sessions
I need English only, thanks...
Chris SaxonConverting Unique Index to Non-Unique
Hi, TOM!Some time ago I decided to change my unique index to non-unique because of new requirements. I googled a lot but didn't find anything about <b>convertation</b>.Though I found solutions like creating new nnon-unique index with extra constant field in it...
Chris Saxoncreating a table with columns longer than 30 characters
Hi All, I am creating a table dynamically whose one column name exceeds more than 30 characters.So i am not able to create the table .I tried by keeping the column name within double quotes( " "). But it throw me the same error.is there any way to achieve...
Connor McDonaldConvert arbitrary length numbers from decimal to binary to decimal in PLSQL
Hi,We are storing a 100 digit length number in a varchar2 field in oracle database table column.In PLSQL code, we need to convert this 100 digit number to its binary equivalent (300+ digits), add some more digits to binary and then convert this back to decimal...

Resources