How to make Credit Card Payment using cheq(what to write ?)

SBI
SBI CARD NO. XXXX XXXX XXXX XXXX
HDFC
HDFC BANK CARD NO.XXXX XXXX XXXX XXXX
HSBC
HSBC A/C XXXX XXXX XXXX XXXX
CITI BANK
CITIBANK CARD NO.XXXX XXXX XXXX XXXX
ICICI
ICICI BANK CARD NO. XXXX XXXX XXXX XXXX

ABN AMRO BANK
AAB Card No. XXXX XXXX XXXX XXXX

Skypak provides cheq collection for various banks except HDFC and some other.
Skypak - Bangalore 
Phone : 080-41155090
              080-41161395
Address : 
No:38,Panna Sadan(house name)
Pallani Madhurai Street
Hallasoor
Above co-operative bank
Bangalore

Read more


How to determine whether your computer is running a 32-bit version or a 64-bit version of the Windows operating system?

Note :
Intel Itanium-based computers can only run 64-bit versions of Windows. Intel Itanium-based computers cannot run a 32-bit Windows operating system. Currently, 64-bit versions of Windows only run on Itanium-based computers and AMD64-based computers.
Note 2 :
Click on Start > Run. Type 'winmsd' to display the 'System Information' window.
Look at the 'Item' column for the following entries:
OS Name - If the OS is a 64-bit version, it is listed in the Value column. If not, then it is a 32-bit version by default.
Processor - Find the processor module to determine if the CPU is a 64-bit CPU, such as 'ia64'. This is an Itanium 64-bit CPU.

Windows Vista
Method 1
1.Click Start Start button , type system in the Start Search box, and then click system in the Programs list.
2.The operating system appears as follows:
•For a 64-bit version operating system: 64-bit Operating System appears for the System type under System.
•For a 32-bit version operating system: 32-bit Operating System appears for the System type under System.
Method 2
1.Click Start Start button , type system in the Start Search box, and then click System Information in the Programs list.
2.The operating system appears as follows:
•For a 64-bit version operating system: x64-based PC appears for the System type under Item.
•For a 32-bit version operating system: x86-based PC appears for the System type under Item.

Microsoft Windows XP Professional
Method 1
1.Click Start, click Run, type sysdm.cpl, and then click OK.
2.Click the General tab. The operating system appears as follows:
•For a 64-bit version operating system: Microsoft Windows XP Professional x64 Edition Version <> appears under System.
•For a 32-bit version operating system: Microsoft Windows XP Professional Version<> appears under System.
Note is a placeholder for a year.
Method 2
1.Click Start, click Run, type winmsd.exe, and then click OK.
2.In the details pane, locate Processor under Item. Note the value.
•If the value that corresponds to Processor starts with x86, the computer is running a 32-bit version of the Windows operating system.
•If the value that corresponds to Processor starts with ia64 or AMD64, the computer is running a 64-bit version of the Windows operating system.

Microsoft Windows Server 2003
Method 1
1.Click Start, click Run, type sysdm.cpl, and then click OK.
2.Click the General tab. The operating system appears as follows:
•For a 64-bit version operating system: Microsoft Windows Server 2003 Enterprise x64 Edition appears under System.
•For a 32-bit version operating system: Microsoft Windows Server 2003 Enterprise Edition appears under System.
Method 2
1.Click Start, click Run, type winmsd.exe, and then click OK.
2.In the details pane, locate Processor under Item. Note the value.
•If the value that corresponds to Processor starts with x86, the computer is running a 32-bit version of the Windows operating system.
•If the value that corresponds to Processor starts with EM64T or ia64, the computer is running a 64-bit version of the Windows operating system.

Read more


HTML Basics

Versions of HTML
HTML 1.0 -->> HTML 2.0-->>HTML 3.0 -->> HTML 3.2 -->> HTML 4.0 -->>HTML 4.01-->>XHTML 1.0
What is DTD ?
A DTD in an XML or HTML document provides a list of the elements, attributes, comments, notes, and entities contained in the document. It also indicates their relationship to one another within the document. In other words, a DTD is the grammar of an XML or HTML document.
Purpose of a DTD
When using a DTD for an XML document (including XHTML), the DTD is there to provide structure for your documents. It is easy to write an XML document, but without the DTD, it has no syntactic meaning to the computer. For example, if you come across this portion of an XML document:
"<"address">"
"<"street">"123 Any Street"<"/street">"
"<"city">"Giridar"<"/city">" "<"state">"AP"<"/state">"
"<"/address">"
While you would know it was an address, you wouldn't know whether it was an address the computer was supposed to create from a database table, if that address was for mailing, and other things. The computer, on the other hand, wouldn't see this as anything more than a string of text. If you viewed it in an XML browser, you might not get any errors, but you also wouldn't get a very interesting or useful page.
In other articles, we'll explore the inner workings of a DTD, and examine the elements that make up a DTD. You'll learn what an element, attribute, entity, and notation is and how to use them within your own DTDs. Plus, you'll learn how to read other DTDs so that you can use them in your own XML documents.
Using DIV Tag
"<"div">" Description:
The "<"div">" element defines logical divisions within the document. This means that when you use a "<"div">" element, you are indicating that the enclosed content is a specific section of the page. The "<"div">" element is typically used in XHTML+CSS documents to position portions of the page.
The "<"div">" tag is a block-level element.
"<"div">" Web Browser Support:
• Netscape 2, 3, 4, 6, 7
• Mozilla 1
• Firefox 1
• Internet Explorer 3, 4, 5, 6
• Opera 3, 4, 5, 6, 7, 8
• Safari 1
• WebTV/MSN TV
• AvantGo Palm OS
• AvantGo Windows CE
• HTML 4.0
• XHTML 1.0: XHTML Text Module

Read more


Oracle Basic FAQ's

Wonderful Oracle Faqs are in the following links


SQL Commands for interviews : 

  • SQL Query to Find Duplicate Names in a Table

SELECT Names,COUNT(*) AS Occurrence FROM  Users1 GROUP BY Names HAVING COUNT(*)>1;   

  • SQL to find nth highest salary 
select * from(
select ename, sal, dense_rank() 
over(order by sal desc)r from Employee) where r=&n;
  • SQL query to find second highest salary
 select *from employee where 
salary=(select Max(salary) from employee);


1. Difference between Instance and Database?
The terms instance and database are closely related, but don't refer to the same thing. The database is the set of files where application data (the reason for a database) and meta data is stored. An instance is the software (and memory) that Oracle uses to manipulate the data in the database. In order for the instance to be able to manipulate that data, the instance must open the database. A database can be opened (or mounted) by more than one instance; however, an instance can open at most one database.
2. How to connect to new database in oracle?
sqlplus username/password@connect_identifier
SQL> connect username/password@connect_identifier
To hide your password, enter the CONNECT command in the form:
SQL> connect username@connect_identifier
You will be prompted to enter your password.
In windows another ex usage :
SQL> connect sys@connect_identifier as sysdba
Enterpassword :
Connected.
3. How to create a new user in a particular database?
CREATE USER user_name IDENTIFIED BY password;
CREATE USER uwclass IDENTIFIED BY uwclass;
CREATE USER user IDENTIFIED {BY password |
EXTERNALLY}
4. How to alter a user?
ALTER USER sidney IDENTIFIED BY second_2nd_pwd DEFAULT TABLESPACE exmple;
ALTER USER sh PROFILE new_profile;
ALTER USER sh DEFAULT ROLE ALL EXCEPT dw_manager;
ALTER USER app_user1 IDENTIFIED GLOBALLY AS 'CN=tom,O=oracle,C=US';
ALTER USER sidney PASSWORD EXPIRE;
ALTER USER sh TEMPORARY TABLESPACE tbs_grp_01;
ALTER USER app_user1 GRANT CONNECT THROUGH sh WITH ROLE warehouse_user;
ALTER USER app_user1 REVOKE CONNECT THROUGH sh;
ALTER USER sully GRANT CONNECT THROUGH OAS1 AUTHENTICATED USING PASSWORD;
5. How to see existing users in Oracle Database?
select name from sys.user$;
select username,password from dba_users;
6. How to change the existing user password in the present oracle database?
alter user myuser identified by my!supersecretpassword;
grant connect to myuser identified by my!supersecretpassword
update sys.user$ set password='F894844C34402B67' where name='SCOTT'; (restart of the database necessary)
SQL*Plus command: password or password username
7. How to launch the database configuration assistant tool in Oracle?
Go to $ORACLEHOME/bin
And run the “dbca” binary.
/app/oracle/product/10.2.0/Db_1/bin/dbca
8.Oracle Versions
Oracle products have historically followed their own release-numbering and naming conventions. With the Oracle RDBMS 10g release, Oracle Corporation started standardizing all current versions of its major products using the "10g" label, although some sources continued to refer to Oracle Applications Release 11i as Oracle 11i. Major database-related products and some of their versions include:
• Oracle Application Server 10g (also known as "Oracle AS 10g"): a middleware product;
• Oracle Applications Release 11i (aka Oracle e-Business Suite, Oracle Financials or Oracle 11i): a suite of business applications;
• Oracle Developer Suite 10g (9.0.4);
• Oracle JDeveloper 10g: a Java integrated development environment;
Since version 7, Oracle's RDBMS release numbering has used the following codes:
• Oracle7: 7.0.16 — 7.3.4
• Oracle8 Database: 8.0.3 — 8.0.6
• Oracle8i Database Release 1: 8.1.5.0 — 8.1.5.1
• Oracle8i Database Release 2: 8.1.6.0 — 8.1.6.3
• Oracle8i Database Release 3: 8.1.7.0 — 8.1.7.4
• Oracle9i Database Release 1: 9.0.1.0 — 9.0.1.5 (Latest current patchset as of December 2003)
• Oracle9i Database Release 2: 9.2.0.1 — 9.2.0.8 (Latest current patchset as of April 2007)
• Oracle Database 10g Release 1: 10.1.0.2 — 10.1.0.5 (Latest current patchset as of February 2006)
• Oracle Database 10g Release 2: 10.2.0.1 — 10.2.0.3 (Latest current patchset as of November 2006)
• Oracle Database 11g Release 1: 11.1.0.6 — no patchset available as of October 2007
The version numbering syntax within each release follows the pattern: major.maintenance.application-server.component-specific.platform-specific.
For example, "10.2.0.1 for 64-bit Solaris" means: 10th major version of Oracle, maintenance level 2, Oracle Application Server (OracleAS) 0, level 1 for Solaris 64-bit.

9. How to see exixsting Oracle Version on the system ?
1)select * from v$version;
10.How do we know which version of oracle we are using ?
I need to know whether it is 32 bit Or 64 bit.

From the unix prompt enter , then enter
bash-2.05$ file oracle
a. A 32 bit oracle server will return:
oracle: ELF 32-bit MSB executable SPARC Version 1,
dynamically linked, not stripped.

b. A 64 bit oracle server will return:
oracle: ELF 64-bit MSB executable SPARCV9 Version 1,
dynamically linked, not stripped.

11.How to see the Patches applied on existing Oracle

$ORACLE_HOME/OPatch/opatch lsinventory

opatch does not list the patches applied on DB. it lists the interim patches applied on oracle binaries.

the patched applied on DB are listed with
SQL> select * from registry$history;



How to create a password policy to not to use the used password for any users?
CREATE PROFILE krish LIMIT
 PASSWORD_REUSE_TIME UNLIMITED
 PASSWORD_REUSE_MAX 10;COMMIT;
 /* when a user is assigned with above policy he cant reuse the password again */

-- Add user CDSSCHEMA. This MUST exist for Oracle schema creation.
-- CDS explicitly addresses the schema, and they way Oracle
-- names a schema is by the user name that creates it.
-- The password should be changed from the default value 'tivoli'.

CREATE USER CDSSCHEMA
  IDENTIFIED BY oracle
  DEFAULT TABLESPACE cds_ts123
  TEMPORARY TABLESPACE cds_temp_ts123
  QUOTA UNLIMITED ON cds_ts123
  PROFILE krish;
COMMIT;

The above will create a user called CDSSCHEMA and the he will be under profile krish and hence he cant re-use the same password again.
GRANT CONNECT, RESOURCE, ALTER SESSION, CREATE SEQUENCE, CREATE SESSION,
      CREATE SYNONYM, CREATE TABLE, CREATE VIEW, UNLIMITED TABLESPACE
  TO CDSSCHEMA
IDENTIFIED BY oracle ;
COMMIT;
the above will through error because of the not to use used passwords policy.
/* GRANT will reset the passowrd to new one , it will change the existing password if we specify identified by is given */
 Error sample
GRANT CONNECT, RESOURCE, ALTER SESSION, CREATE SEQUENCE, CREATE SESSION,
*
ERROR at line 1:
ORA-28007: the password cannot be reused

How to avoid overlapping of  columns when working on SQL prompts (DOS/UNIX )?
SQL> set wrap off


How to upgrade Oracle 9i(or lower) version to 10g ?

Oracle 9i to 10g

ORcle 9i to 10g upgrade.pdf


How do I execute an SQL script file in SQLPlus?
To execute a script file in SQLPlus, type @ and then the file name.

SQL >  @{file}

For example, if your file was called script.sql, you'd type the following command at the SQL prompt:

SQL >  @script.sql

The above command assumes that the file is in the current directory. (ie: the current directory is usually the directory that you were located in before you launched SQLPlus.)

If you need to execute a script file that is not in the current directory, you would type:

SQL >  @{path}{file}

For example:

SQL >  @/oracle/scripts/script.sql

This command would run a script file called script.sql that was located in the /oracle/scripts directory.

what does i stands for in oracle 8i and oracle 9i ?
i stands for internet in oracle 8i and 9i

What does g stands for in oracle 10g ?
g stands for grid technology in Oracle 10g.
from 10g onwards oracle supports grid architecture.

How to see the existing constrains applied on a table columns?

select constraint_name, constraint_type from user_constraints where table_name='';

Ex : table name : call_qr_nortel_active
select constraint_name, constraint_type from user_constraints where table_name='call_qr_nortel_active';

what is this grid computing ? 
[1] [2] [3] [pdf] [4]

Write a typical insert command to put system date as the date column data ?


insert into call_qr_nortel_active values(sysdate,1,'cProbe:15','iProbe:30','3215551234','3215551234','192.168.2.10:',
'192.18.2.10:','11-APR-2008',12,'E1:30',999,'192.168.2.10:160','192.168.2.10:460',70,
8,41,33,3,5,999,4,33,600,999,'92.168.3.10:48160','192.168.3.10:49160',
54,23,45,33,5,23,999,6,33,5000,677,'unknown data value',
33,'16:40',4,3);

Read more


Short-hand form of communication in chating. (chat JARGANS)

Many of my friends ask me what is BRB for the first time. If you do not interact online, chances are that you will not know most of the terms like IMO, BTW, CU, OO etc. Well don’t worry... You have dropped in the right place... Check this site that contains hundreds of such short forms used in conversation as a sort of short-hand form of communication.
URL to find meaning of your JARGON
here is my own list
AKA = Also Known As
ASAP = As Soon As Possible
ASL = Age/Sex/Location
BRB= Be Right Back
CU = See You
CUL8R = See You Later
FYI = For Your Information
IMHO = In My Humble Opinion
IOW = In Other Words
K = Ok
LOL = laughing out loud
MYOB = mind your own business
RSVP = Repondez, s'il vous plait (Respond, please)
W/O = without." W/ means "with."
WTG = way to go
TTYL=Talk To You Later

Read more


Corporate language ....

1."We will do it" means" You will do it"

2."You have done a great job" means" More work to be given to you"

3."We are working on it" means" We have not yet started working on the same"

4."Tomorrow first thing in the morning" means" Its not
getting done "At least not tomorrow!".

5."After discussion we will decide-I am very open to views"
means" I have already decided, I will tell you what to do"

6."There was a slight miscommunication" means" We had actually lied"

7."Lets call a meeting and discuss" means" I have no time now, will talk later"

8."We can always do it" means" We actually cannot do the same on time"

9."We are on the right track but there needs to be a slight
extension of the deadline" means "The project is screwed up, we cannot
deliver on time."

10."We had slight differences of opinion "means" We had actually fought"

11."Make a list of the work that you do and let's see how I
can help you" means" Anyway you have to find a way out no help from me"

12."You should have told me earlier" means" Well even if
you told me earlier that would have made hardly any difference!"

13."We need to find out the real reason" means" Well I will tell you where your fault is"

14."Well Family is important, your leave is always granted.
Just ensure that the work is not affected," means," Well you know..."

15."We are a team," means," I am not the only one to be blamed"

16."That's actually a good question" means "I do not know anything about it"

17."All the Best" means" You are in trouble"

Read more

Popular Posts

Enter your email address:

Buffs ...

Tags


Powered by WidgetsForFree