Try this
SELECT COUNT(employee_ no),hire_date FROM EMPLOYEE GROUP BY trunc(hire_date ) HAVING hire_date IN ()
Thanks
Dilip
Dilip1983
Last Activity: Sep 17 '08, 06:31 PM
Joined: Jan 17 '08
Location:
-
Output following Command
Hi All
I am using the following command to get the output like this
home1
pandadk
sandbox
odm
odm_daa
pub_odm_daa_tes t1
run
But it is returning me nothing.Code:echo "/home1/pandadk/sandbox/odm/odm_daa/pub_odm_daa_test1/run"|awk '{split($0,a,"/"); for(i=1; i<=NF; i++) print a[i]}'
Please advise.
Thanks
... -
Connect to UNIX Server
Hi All
Is it possible to Connect to UNIX Server with User name/password credentials and do some manipulations and show the output/report.
If it is possible then how to proceed with this?
Thanks
Dilip -
Use outer join to achieve your output.
Let me know if you are not able to prepare the query.
It's not a hard query,You can try this out.
Thanks
DilipLeave a comment:
-
You can create a function to see your output in rows/columns with out writing a big SQL query.
Thanks
DilipLeave a comment:
-
Any Inputs on this???
Thanks
DilipLeave a comment:
-
You can try using EXIST inplace of IN.
This might give some more performance.
Thanks
DilipLeave a comment:
-
I have already tried to write the query which will delete duplicate records.
Query:
delete from table where row_id not in
(
select min(row_id) from table group col1,col2,col3, col4
);
Since i am not able delete a single duplicate record from the table with index in unusuable state, the above query also gave the same error.
Finally i had to drop the index and delete the duplicate...Leave a comment:
-
You can disable the constraint by using alter table statement.
Then insert records into it.
But if there will be duplicate records you won't be able to create a Primary Key on that column.Leave a comment:
-
Variables store output of SQL queries to be used further inisde a PLSQL block or SQL Query.Leave a comment:
-
I tried using alter session SKIP_INDEX_UNUS UABLE=TRUE
Still i could not delete the records.
Thanks
DilipLeave a comment:
-
Oracle Internal Error Code(Oracle Version:10.2)
Hi
I am getting following error while joining flow of data from a file and table using Abinitio Component.
select contact_key,bil l_accnt_key,pr_ contact_for_bac _flg,relationsh ip_type,deleted _flg,ts_last_up d from contact_bac_rel where bill_accnt_key= :loc
ORA-00600: internal error code, arguments: [kpofdr-long], [], [], [], [], [], [], []
I want to know the reason for this error.
... -
Thanks Debashish
I wanted to delete the records from that table with out dropping the index or truncating the table.
Is there anyway for this
Thanks
DilipLeave a comment:
-
Try to_date(start_d ate,'DD/12/YYYY').
Let me know if it helps or not.Leave a comment:
-
Delete Duplicate Records from a large table
Hi All,
I want to delete duplicate records from a large table.
There is one index(INDEX_U1) on 4 columns(col1,co l2,col3,col4) which is in unusable state.
First of all when i tried to rebuild index it showed error as unique key violation.
So i want to delete duplicate records for col1,col2,col3, col4 combination.
How can i delete the duplicate records from this large table?
... -
How to know what mother board i am using?
Thanks
DilipLeave a comment:
-
Audio Driver Not getting installed in Windows XP
Hi,
I am unable to install ac 97 realtek audio driver in my system(Windows XP).
Earlier i tried to install Realtek Audio Driver in Windows XP which gave me error(Install Realtek HD Audio Driver Failure !!). Then i tried to install ac 97 realtek audio driver.
The audio driver got installed in my system but sound is not coming.
Please provide me some suggestions.
Thanks &... -
Maximum number of Columns
Hi Experts,
1.What is the maximum number of columns that are permissible to create a table in Oracle?
2. What is the difference between Correlated Subquery and Nested Subquery?
Thanks & Regards
Dilip -
I am sorry but the command given by u is not working.
My case is 1st one. Can u suggest any other way.
Thanks
Dilip...Leave a comment:
-
Removing columns of a file using vi Editor
Hi Gurus,
The data in the file looks like in this format
1 2233|A.K Shukla |G.M |Sales |12/12/52|6000
2 9876|Jai Sharma |Director |Production |12/03/50|67000
3 5678|Sumit Chakarborty |D.G.M |Marketing |19/04/43|6000
4 2365|Barun Sengupta |Director |Personnel |11/05/47|7800
5 5423|N.K. Gupta |Chairman |Admin |30/08/56|5400...
No activity results to display
Leave a comment: