amitpatel66
Last Activity: Mar 20 '11, 03:55 PM
Joined: Mar 22 '07
Location: Hyderabad, India
-
Thats called pivot. Which version of database are you using? -
From Excel?...write a macro and connect to oracle database using odbc drivers...Leave a comment:
-
Leave a comment:
-
Its becuase of incorrect syntax. You need to use something like this:
[code=oracle]
UPDATE CRPDTAMX1.F55UK RQ A
Set A.KQZKV8='PMX', A.KQZKV9 ='PMX', A.KQZKSTS ='Submit', A.KQZKCDE ='1'
Where EXISTS (SELECT 1 FROM CRPDTAMX1.F55UK RQ C
WHERE A.KQZKID=B.KQZK ID)
/
[/code]
You can add all your conditions for table CRPDTAMX1.F55UK RQ in the above queryLeave a comment:
-
Are you looking at using an INLINE VIEW instead of a table in select query?Leave a comment:
-
I just missed that it has to be a prime number. In that case you will need to store the list of prime numbers seperately and associate those with the value. Else if single query is built to generate prime numbers as well, it would be not so good performance wise.Leave a comment:
-
you will need to change the characterset at database level.
But why you need to do so? From your php page, you are able to see the data correctly isnt it?Leave a comment:
-
Try this:
...Code:SQL> ed Wrote file afiedt.buf 1 with t as (SELECT 'MILK' col1,'SUGAR' col2,'BUTTER' col3,'CHEESE' col4 from dual 2 union select NULL,'SUGAR','BUTTER',NULL from dual), 3 s as (SELECT col1,(CASE WHEN col1 IS NULL THEN 0 ELSE ROW_NUMBER() OVER(ORDER BY col1) END ) rn 4 (SELECT col1 from t 5 UNION 6 select col2 from t 7 UNION
Leave a comment:
-
Did you try executing a query? I am sure it will not be having any performance issue.
Can you post an explain plan for the query to check?Leave a comment:
-
Check if the datatype of the column deptno is Varchar in the table? Also using TO_NUMBER is to convert the value to number externally.Leave a comment:
-
Check if this helps:
...Code:PROCEDURE PRINT_REP_WEB IS RO_Report_ID REPORT_OBJECT; Str_Report_Server_Job VARCHAR2(100); Str_Job_ID VARCHAR2(100); Str_URL VARCHAR2(100); PL_ID PARAMLIST ; BEGIN PL_ID := GET_PARAMETER_LIST('TEMPDATA'); IF NOT ID_NULL(PL_ID) THEN DESTROY_PARAMETER_LIST(PL_ID); END IF;Leave a comment:
-
Are you facing any issue? can you post the error that you are facing?Leave a comment:
-
Try this:
Code:SELECT last_name, TO_CHAR(hire_date, 'DD-Mon-yyyy') from employees WHERE TO_DATE(hire_date, 'DD-Mon-YYYY') < TO_DATE('01-Jan-1990','DD-Mon-RRRR'); /Leave a comment:
-
Is your fmb a custom one or a standard one? Then I am afraid you will need to create a copy of that fmb with different name and assign the same to another function and apply the personalization to the same.Leave a comment:
-
What is the error that you are facing?Leave a comment:
-
Something like this:
[code=oracle]
-- In case procedures output variables return type is NUMBER
SQL>VAR my_out1 NUMBER
SQL>VAR my_out2 NUMBER
SQL>VAR my_out3 NUMBER
SQL> EXEC my_proc(10,20,: my_out1,:my_out 2,:my_out3);
SQL> PRINT :my_out1 :my_out2 :my_out3
[/code]Leave a comment:
-
You can open the particular form to which the function is assigned that you want to customize then you can do your customization using forms personalization .
I am not sure what you are exactly trying to achieve.
If you can provide more information would help.Leave a comment:
-
How would you like to use a fmb file? place the fmb in the unix box, compile the same to generate a fmx and register the same in oracle applications.Leave a comment:
-
Then you can use IMP and EXP utility to transfer the database objects from one system to another.
Google for IMP and EXP utility in oracle and you will find lot of information.Leave a comment:
-
Try this:
[code=oracle]
SQL> ed
Wrote file afiedt.buf
1 SELECT fff.function_na me,
2 ff.form_name,
3 ffft.user_funct ion_name,
4 fff.function_id ,
5 ff.form_id,
6 fff.application _id
7 FROM fnd_form ff,
8 fnd_form_functi ons fff,
9 fnd_form_functi ons_tl ffft
10 WHERE...Leave a comment:
No activity results to display
Leave a comment: