Oraclesteps

Home
Contact Me
PL/SQL Developer User
SQL & PL/SQL Interview Questions
Oracle Reports
PL/SQL Tutorials
SQL Tutorials

Contact Me

1:34 AM | Posted by Unknown | | | Edit Page

Mail To :
tarunendratripathi@gmail.com

0 comments:

Post a Comment

Subscribe to: Posts (Atom)

Popular Posts

How to update a rows with opposite gender in Sql?

SQL :> Select Decode (Gender,Male,Female,Female,Male) From Table_Name;
what is diff bet sub-query and corrrelated sub-query?

Sub-query - The inner query execute first, the outer query deprnds on inner query output. Correlated sub-query - The outer query execute ...
Removing Duplicate Rows from a Table.

Use rowid pseudo column. All you have to do is to keep the latest data (i.e. highest ROWID) and remove other duplicated rows. SELECT * FROM...
Updating Multiple columns using values from another column.

update table_name set (col1,col2,col3)=(select t.col4,t.col5,t.col6 from table_name2 t where something) OR create table tgt ( id num...
what is external tables and how and inwhich case we should use this?

external tables are mainly used when we have the data in flat files and we need to import that data into database then we go for external ...
How to track last update date on a particular record without DBA help.

we can get the last updated date based on the following inbuild function: scn_to_timestamp(max(ora_rowscn)) Example: create table ...

Blogger templates

Blogger news

Blogroll

Archive

▼ 2014 (1)
- ▼ September (1)
  - ▼ Sep 13 (1)
    - How to update a rows with opposite gender in Sql?

► 2012 (5)
- ► August (5)
  - ► Aug 28 (1)
  - ► Aug 27 (4)

Pages

Home
SQL Tutorials
PL/SQL Tutorials
Oracle Reports
SQL & PL/SQL Interview Questions
PL/SQL Developer User
Contact Me

Powered by Blogger.

Labels

sql problems (2)
Triggers (1)

About Me

Unknown

View my complete profile

Followers

Follow us on FaceBook

Blog | About | Contacts

Designed by Gyanu Basnet.