Hi,
I want to send mail to the user in which I have the url. On clicking that url, they should be able to view all the information. The dns alias of the server is abc/sps/mot, the script is written in such a way the url sent is abc.sps.mot.com .
Now, the dns alias will be changed to abc.xyz.net and the host name should be in this format, abc.am.xyz.net.
Can anyone please guide me in solving this?
...
Vinarashi
Last Activity: Mar 18 '11, 12:52 PM
Joined: Sep 22 '10
Location:
-
How to get the server name using the lotus notes scripts?
-
Hi Amit,
I have tried in that way also. Still its not working.
For "select * ", I am getting all the values. But "select <column_name> " getting error as ORA-0600 - Internal error code.
Thanks a ton Amit.
Regards,
Flora -
Hi Amit,
Thanks for you reply..
I have tried the above statement. If i give the value of EMPLOYEES_NAME as something which is not available in the table, it gives 0 rows.
Whereas if I give the value of EMPLOYEES_NAME as any of the data which is available in the table under EMPLOYEES_NAME column, its gives an error. The error message is "ORA-00600: internal error code, arguments: []......"
...Leave a comment:
-
Hi,
Thanks for your reply..
This is the view definition.
CREATE OR REPLACE FORCE VIEW "LOS_AT"."SERVC _MGR_REPT_V_CEL L" ("MANAGERS_CID" , "MANAGERS_NAME" , "SERVICE", "EMPLOYEES_CID" , "EMPLOYEES_NAME ", "EMPLOYEES_HR_S TATUS", "EMP_LOCATI ON", "COUNTRY", "DEPT", "CHARGED_IT EM", "YTD",...Leave a comment:
-
how to get a particular column alone in select statement?
Hi,
I have given a "select *" statement for a view. It gives all the values for the "where" condition mentioned. But when I give "select column_name " for the same "where" condition, I am getting an error.
e.g.
if I give "select * from SERVC_MGR_REPT_ V_CELL where EMPLOYEES_NAME= 'Ma, Stephen';", I am getting all the values.
But if I give "select MANAGERS_NAME... -
Vinarashi started a topic How to reject the data when particular column value is null in sql loader?in OracleHow to reject the data when particular column value is null in sql loader?
Hi,
I am trying to load a data file into database. The data should be rejected if one particular column is null. As far as i googled, there is only one way, I should make that column "not null" in database. But already some null values are available. So I dont want to disturb that.
If I include "when" in the load command,the data is not getting rejected. It is getting skipped. I want the data to be... -
Thanks a lot...Leave a comment:
-
How to give from address in mutt command while sending mail in unix?
Hi,
Can anyone please guide me?
I am trying to send mail using mutt command along with an attachment. Earlier i tried with uuencode, elm, sendEmail, mailx commands. But my server doesnot support these commands. Thats why I tried using mutt command. I am able to receive the mail notification.No w the problem is, in the from address i am getting the server account name.I have tried with -f command. But it is not getting... -
Whats the problem in mail command??
Hi,
Anyone please help me in solving this issue?
How to attach a file using mail command in Linux?
I tried with uuencode " " " " | mailx command, but i am getting an error "uuencode command not found".
Thanks to everyone.
Flora. -
Hi,
Try with this...
echo "listener is down" | mailx -s "<some_subject> " $DBALISTLeave a comment:
-
How to skip the bad record and continue the loading in SQL loader?
Hi,
I am trying to load data file into database in sql loader. How to skip the bad record alone and continue with loading?
For eg. I am trying to load data file which has 100 records.The 50th record encounters an error.At present only 49 records gets loaded and it stops from 50th record. I want first 49 records as well as 51st to 100th record to be loaded at the same time and 50th records should be written in the bad...
No activity results to display
Leave a comment: