Oraclesteps
Home
Contact Me
PL/SQL Developer User
SQL & PL/SQL Interview Questions
Oracle Reports
PL/SQL Tutorials
SQL Tutorials
SQL Tutorials
3:53 AM
|
Posted by
Unknown
| |
|
Edit Page
0 comments:
Home
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
0 comments:
Post a Comment