Skip to Main Content
Ask TOM
Site Feedback
Sign In
Questions
Office Hours
Videos
Resources
Classes
Ask The Oracle Mentors
Recently Answered
Ask a Question
All Questions
Recently Answered 2.0
#SELECTION#
Generate N TIMESTAMPs
I need to CREATE some test data where I want to CREATE N number of timestamps between 2 times for every 15 minute interval including the start time and less than the end time. N would be defined as dbms_random between a low_number and a high_number. I want to run something like t...
#MISC#
#ACTIONS#
#SELECTION#
SYS.DBMS_NETWORK_ACL_ADMIN
ORA-04063: package body "SYS.DBMS_NETWORK_ACL_ADMIN" has errors, how do I reinstall this package?
#MISC#
#ACTIONS#
#SELECTION#
Bind variables in Live SQL
Dear Tom, how can I create bind variable in Oracle Live SQL, <variable variable_name data_type;> example <variable dusko number;> just doesn't work, i get "Ussuported command" message... Thanks and best regards
#MISC#
#ACTIONS#
#SELECTION#
Using Dynamic Table Name in Select Statement To Prepare Extract File
Hi. We use to prepare extract file from oracle using extract script. There are few tables whose name gets change every month. Need to handle these table names dynamically. SELECT TICKET_ID ,SOURCE_ID ,SERV_ID ,to_char(COLLECTED_DATE,'YYYY-MM-DD HH24:MI:SS')
#MISC#
#ACTIONS#
#SELECTION#
Grouping and updating column with equal parts
Hi, I have a table that holds about 2 million records. No column in the table can be used to divide rows equally. Initially when the data is loaded into the table, the bucket_number column is null. After data loaded, I would like to calculate and equally divide the total no. of r...
#MISC#
#ACTIONS#
Upcoming Office Hours
All Office Hours
Upcoming Office Hours Cards
Free training, how-tos and Q&A with Oracle experts, every month!
Learn more