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 does sharding mean?

1052

Which is better Oracle or MS SQL? Why?

5029

Is insert autocommit in oracle?

1129

What is format trigger?

2120

How to create a table index in oracle?

1181

What is the dynamic sql in oracle?

1124

How can we force the database to use the user specified rollback segment?

1197

Point out the difference between user tables and data dictionary?

1032

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2342

What happens to the current transaction if the session is killed?

1033

How many types of auditing in Oracle?

1086

When do we use group by clause in a sql query?

1098

What is connection pool in oracle?

1034

How to change system global area (sga) in oracle?

1063

What are the varoius components of physical database structure of oracle database?

1038