Sitemap

Amicuk Programming Answers

Query from User_Scheduler_Jobs returns no rows in version 2.1.0.63

-0001-11-30   Views:2

Advertisement

Using version 2.1.0.63, "select * from user_scheduler_jobs;" returns no rows. It works ok in version 1.5.5. Edited by: User65423 on Feb 8, 2010 9:24 AMRefer to this thread, where the cause seems to be due to SQL Developer not handling null inter

Using version 2.1.0.63, "select * from user_scheduler_jobs;" returns no rows. It works ok in version 1.5.5.
Edited by: User65423 on Feb 8, 2010 9:24 AM

The replay answer
Advertisement
Refer to this thread, where the cause seems to be due to SQL Developer not handling null interval data types.
bug? F9 gives no output dba_scheduler_jobs, version: 2.1.0.63.73
As mentioned in that thread you can use to_char on the interval columns as a work-around...
SELECT source,
destination,
comments,
flags,
job_name,
job_creator,
client_id,
global_uid,
program_owner,
program_name,
job_type,
job_action,
number_of_arguments,
schedule_owner,
schedule_name,
start_date,
repeat_interval,
end_date,
job_class,
enabled,
auto_drop,
restartable,
state,
job_priority,
run_count,
max_runs,
failure_count,
max_failures,
retry_count,
last_start_date,
TO_CHAR(last_run_duration),
next_run_date,
TO_CHAR(schedule_limit),
TO_CHAR(max_run_duration),
logging_level,
stop_on_window_close,
instance_stickiness,
system,
job_weight,
nls_env
FROM user_scheduler_jobs a;

Go to See the other 3 answers

Query from User_Scheduler_Jobs returns no rows in version 2.1.0.63

Category:DefaultRelease time:-0001-11-30Views:130

Using version 2.1.0.63, "select * from user_scheduler_jobs;" returns no rows. It works ok in version 1.5.5. Edited by: User65423 on Feb 8, 2010 9:24 AMRefer to this thread, where the cause seems to be due to SQL Developer not handling null inter[More]

SQL Query (PL/SQL Function Body returning SQL query) doesn't return any row

Category:DefaultRelease time:2015-10-11Views:130

I have a region with the following type: SQL Query (PL/SQL Function Body returning SQL query). In a search screen the users can enter different numbers, separated by an ENTER. I want to check these numbers by replacing the ENTER, which is CHR(13) ||[More]

Query with XMLTABLE returns null rows

Category:DefaultRelease time:-0001-11-30Views:130

Hello all, I'm trying a query with XMLTABLE, but even thought the number of returned rows is correct, the row content is (null). DB version is: 10.2.0.4.0 Here is my query; SELECT s.DESCRIPTION FROM EXECUTIONPLAN p,   XMLTABLE   ('//executionPlan/exe[More]

Bug Report: ResultSet.isLast() returns false when queries return zero rows

Category:DefaultRelease time:2015-10-11Views:130

When calling the method isLast() on a resultset that contains zero (0) rows, false is returned. If a resultset contains no rows, isLast() should return true because returning false would indicate that there are more rows to be retrieved. Try the foll[More]

Query executed within a plug-in script returns 0 rows, although data exists

Category:DefaultRelease time:2015-10-11Views:130

I created a plug-in script for algorithm entity: Service Quantity Rule. The script calls a business service that I created using query zones. The query returns the values of the bill segment (ci.bseg.bseg_id and ci_bseg.closing_bseg_sw) that is creat[More]

Query to return separate rows for date range including NULLs

Category:DefaultRelease time:2015-10-11Views:130

I'm trying to write a query that will return all customers from table 1. Table 1 also provides a start date and an end date that may be different for different customers. Left join with Table 2  provides all matches and NULL if NO matches. If there i[More]

Query to return ALL rows even those with zero counts

Category:DefaultRelease time:2015-10-11Views:130

Hi, The following query will return only those rows that have a non zero count value: select c.id, a.name, count(*) as XYZ from CON c, CUST a where c.help !='1' and (c.id = a.id) group by c.id, a.name order by c.id; The results are: 1 ME 3 3 YOU 4 Wh[More]

Silly old fogey (me) cannot figure out why this query returns 1 row

Category:DefaultRelease time:2015-10-11Views:130

Hi all, In reference to {thread:id=2456973}, why does select sum(count(decode(job, 'CLERK', 1, null))) CLERKS , sum(count(decode(job, 'SALESMAN', 1, null))) SALESMANS from emp group by job;only return 1 row and not 1 for each job? I actually had to t[More]

XML attributes makes my query return no rows

Category:DefaultRelease time:2015-10-11Views:130

Hello everyone, I've an odd problem. I'm querying some XML, but the attributes in one of the tags make my query return no rows; if I remove the attributes, then the query works as expected. The XML is below; it's the attributes in the Report tag that[More]

Cascading LOV always returns first row in af:query

Category:DefaultRelease time:-0001-11-30Views:130

HI JDEV 11.1.1.3.0 A strange thing is happening with my cascading LOV which is input text with LOV. I have a read only table with a query section. I then also bring up any of the tables rows in a popup with single record view where the row is then in[More]

Query doesn't return rows

Category:DefaultRelease time:-0001-11-30Views:130

Hi, The following query returns no rows, while there is one row in the table: SELECT * FROM (SELECT id,              amt_disburse amt1,              TO_CHAR (dt_disburse, 'RRRRMMDD') date1       FROM (SELECT a.*,                    ROW_NUMBER ()     [More]

Hot
Hi all, I own a M276nw MFP printer since few days, and I'm unable to use the installed app flawlessly. The printer is connected to a wired LAN with 192.168.128.x address range. There's a router with 192.168.128.26 that gives internet access. All clie [More]
My ipad was stolen this morning; can Verizon track the location of the device an assist the police department in recovering the device? I am filing a police report does Verizon have the serial number of the device for me to include in the police repo [More]
I just installed Firefox 15.0.1 on WIndows XP SP2. Also installed NoScript 2.5.5 and DownloadHelper 4.9.9, current Flash plugin and Shockwave. The browser seems to print fine to all my physical printers. But when I attempt to print to the Adobe PDF p [More]
Using Indd CS5 mac OS 10.6.8 I'm laying out a print book which will also be converted to an ebook using InDesign's convert to EPUB feature. I need to make several websites listed in the resource section live links. Question: Do I need to include http [More]
Hello colleagues! We activated business function LOG_SD_SIMP_02 in order to customize predefined conditions in our system. We have price conditions without indicator Amount/Percent in the condition type, which was removed in order to prevent manual c [More]
Hi All, We are planning to develop a User Management tool which will be running from QA Portal. For this we are planning to develop a WD Java application from which admin can create. modify users, lock and unlock group of users, add roles or modify r [More]
I created a 2nd catalog in the PSE 10 Organizer, but now I cannot find my original catalog. Where is it hiding? The Find > Catalog... option doesn't list any catalogs. I'd appreciate any help with this.Ken, thanks for response but no luck. I did a se [More]
I'm a Mac user in a Windows world. I like "natural scrolling". I've reversed all the windows scrolling by changing all instances of "flipflopwheel" in the registry. This fixed it even for low-level software like Synergy, which lets me [More]
I install FCE HD 3.0 on my Mac Book Pro and when I attempt to open the program I receive a message telling me I do not have an AGP Graphics Card. Should this card already be installed?FCE 3.0 is NOT suitable for the new Intel Macs like your MBP. You [More]
Hoping someone might be able to tell me how to kill a job that doesn't want to die:) We had network maintenance over the weekend that interupted the connection between our app server and database. It caused a bunch of jobs to get stuck. I could kill [More]