Recent content by vijaychin

Just to confirm, make sure you are saving your changes in BIOS and then exiting.

I came across the following article which gives steps to clear the CMOS in situations like this. Just give it a shot. Turn off the computer and any attached devices, such as printers, monitors, and external drives. Unplug all power cords from electrical outlets, and remove the cover. Locate...

In the BIOS, check whether order of booting is Cd drive and then hard disk or not. Make the cd drive the as the first one to be able to use your recovery disk.

ls -1 | awk '{ print substr($0,1,length($0)-1) }'

why don't you remove the share on your pc if u don't want anybody else to access your files.

Even I had problem connecting through vpn to work. My office people gave me a new Cisco VPN client software (must be having a patch). After re-installing the software, I am able to login even if my firewall is on. I have firewall of xp and firewall of the netgear router. So, try to get the...

I had same kind of problem last week. I pressed F8 while booting, and from the menu I chose "return to last known good configuration", and it worked. Try that.

I use buzme free software which shows me the caller id as well as gives me a chance to give reply to the caller as "will call back in X min. or call me back in X min.".

ORDER BY decode(v_OrderBy,'Col1',1,'Col2',2,3) DESC

This is an implicit cursor attribute. you need not use any cursor for using this. just after your update statement, give this line. dbms_output.put_line(sql%rowcount); you will see the number of rows affected by the previously executed dml statement.

Use sql%rowcount after the update.

Put the entire select in a variable and execute it using 'execute immediate'. refer to the documentation for the usage. its quite simple.

INSERT INTO SUBJECT VALUES ('ARTS ' || chr(38) || ' HUMANITIES','AH');

some records in your text file may not have values for all the fields. so, after enclosed by '^' you should give trailing nullcols by the way your second syntax is correct, giving the 'fields terminated by' before the field list.

yes, you can run from wintnt command window. go to your text file directory and try to execute the command. If the command is not recognized, then try to set the path the oracle folder. even if it doesn't work, copy your text file and ctl file to the oracle/bin directory and execute there.