Ask The Oracle Masters

Recently Answered

	Filters 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...
	Converting 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...
	creating 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...
	Convert 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...