bhushanbagul
Last Activity: Sep 26 '09, 02:08 PM
Joined: Jun 7 '07
Location:
-
Thanks to you amit -
Arbitrary order in SQL query
Hi All,
I want to sort oracle SQL as below
e.g. employee table having column name, now i want to display records where employee names start with letter 'L' should appear first then starts with 'B' and then start with 'F'.
Thanks in advance.
Bhushan -
hi
I have below table structures
Table A:
table_a_id number(10) pk
status nvarchar2(10)
Data for Table A:
1 Approved
Table B
table_b_id number(10) pk
status nvarchar2(10) ...Leave a comment:
-
How to write this query
Hi,
I have below table structures
Id'd Status Id's
Table A: table_a_id number(10) pk Data: 1 Approved
status nvarchar2(10)
Table B table_b_id number(10) pk Data: 1 Paid
status nvarchar2(10) ... -
Amit
Everything is fine about RWX u told still i m facing the same problem, i don't understanding what could be the problem. Is there any other reason bcoz of that OS dening on access by oracle
Regds,
Bhushan...Leave a comment:
-
thanks for the reply,
But i had got the same reply on google when i searched, i need some other solution guys.
Regds,
Bhushan...Leave a comment:
-
ORA-29283: invalid file operation
Hi All,
I m facing mentioned error while executing below code at line no 3.
CREATE or REPLACE DIRECTORY MY_DIR AS '/outputs/EXTRACTS';
GRANT READ,WRITE ON DIRECTORY MY_DIR TO public;
fileID := UTL_FILE.FOPEN( 'MY_DIR', fileName,'W');
I tried all the possibe ways but still not understood what is the problem there.
Please give ur sugeetions guys so i can try.
Thanks &... -
Dear victordaniels4
Please try using the below query.
select 'I' || trim(to_char(IN C_NO,'000000')) from incident;
Post back if any issue
Cheers,
Bhushan...Leave a comment:
-
Hi shahjapan
Please check it also the second way to achieve the same result.
SELECT a.comp_id, a.branch_id
FROM temp a, temp b
WHERE a.ROWID <> b.ROWID
AND a.comp_id || a.branch_id = b.comp_id || b.branch_id
ORDER BY a.comp_id, a.branch_id;
Cheers
Bhushan...Leave a comment:
-
Dear shahjapan
Please execute the below query, it'll give you the desired result.
SELECT temp.comp_id, temp.branch_id
FROM temp,
(SELECT branch_id, comp_id, COUNT (comp_id)
FROM temp
GROUP BY branch_id, comp_id
HAVING COUNT (comp_id) = 2) duplicated_bran ch
WHERE temp.branch_id = duplicated_bran ch.branch_id
AND...Leave a comment:
-
Dear zehava
To get the default values please use below query.
select table_name,colu mn_name, DATA_DEFAULT
from cols
where table_name = upper(<table_na me>)
and column_name = upper(<column_n ame>)
Regds,
Bhushan...Leave a comment:
-
Thanks you so much DEBA...Leave a comment:
-
Dear Debasis
My question is why there is i and g exactly
for e.g 11i or 11g exactly what difference i and g makes here.
Thanks...Leave a comment:
-
what difference i and g makes in oracle version
Hi All
Please let me know exactly what difference i and g makes in oracle version i.e. when we say oracle 10g or oracle 11i
Thanks
Bhushan -
Dear Hastha
Definitely we can use commit inside oracle function but programatically it's not a good practice to use commit inside oracle function because for performing DML operations we have oracle procedures. However i m providing below oracle function for ur reference in which commit has been used.
CREATE OR REPLACE FUNCTION commit_inside_f unc (pi_dml_opr_fla g VARCHAR2)
RETURN NUMBER
IS
...Leave a comment:
-
Hi Abhinav
Please visit below url hope u'll get the better notes on how to use explicit cursors.
http://www.unix.org.ua/orelly/oracle/prog2/ch06_02.htm...Leave a comment:
No activity results to display
Leave a comment: