Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

How to select oracle sequence from different schema and

How to select oracle sequence from different Databases.

Explain with example

Question Posted / harikanth

Answer Posted / harikanth

How to select oracle sequence from different schema

ANS:
a. SCHEMANAME.SEQUENCENAME.CURRVAL.
b. SCHEMANAME.SEQUENCENAME.NEXTVAL

How to select oracle sequence from different Databases

ANS:

a. SCHEMANAME.SEQUENCENAME.CURRVAL@DBLINK
b. SCHEMANAME.SEQUENCENAME.NEXTVAL@DBLINIK

Thanks,
Hari

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the ways tablespaces can be managed and how do they differ?

2360

how to handle exceptions in post production

1414

Explain rename?

970

What are the differences between blob and clob in oracle?

1078

Explain oracle instance.

1165

How do I start tns listener?

1038

How many data types are supported?

1076

What is an oracle wallet?

935

How to execute the package in oracle?

1074

How many types of tables are there in oracle?

1052

How to write a query with a right outer join in oracle?

1155

How to run the anonymous block again?

1122

What are the uses of a database trigger?

987

What is the dynamic sql in oracle?

1062

How to drop an index in oracle?

1060