No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
The below query is updating all the rows in the table1 eventhough the inner query only selects few of the rows. Any help. Appreciate it. Thanks, UPDATE table1 out SET (col1, col2, col3) = (SELECT col1, col2, col3 FROM (SELECT col1, col2, col3 FROM table1 in, table2 a, table3 b … |
|
I need to derive last 2 numbers after the '-' from the code column. example if the code is 76767-99 then I need a query to return only 99. I am using substr and instr functions but not getting what I want. Please help me correct the below query. code … |
|
I have to create a report based on the customer for particular order. For example find all the customers who ordered an item ‘ABC’ for current month and look back 11 months to find out if the same customers ordered the same item and list all the customers who ordered … |
|
I am using the below code to return the pid. But it works only if the pid is 4-digit. It returns nothing if the pid is 5-digit (see the examples). How do I fix this code for both the instances. Thanks in advance! Mamtha pid =ps -fu truecomp | grep … |