Jump to content

lightning

New Members
  • Posts

    5
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

lightning's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I created 2 sets of transactions in php with a sleep command in between. The sleep command is to simulate a transaction taking a long time. Transaction1 in 1 php page: BEGIN Query1 sleep(100) Query2 COMMIT; Transaction2 in another php page: BEGIN Query1 Query2 COMMIT; As soon as the Transaction 1 is executed from 1 php page, I tried to execute the Transaction2 php from another php page. Transaction 2 waited till Transaction 1 completed and then it executed. I want Transaction 2 to end after a few tries. It is because I have a cron job that might take about half an hour and therefore Transaction 2 should end after a few tries with some error messages. How is it done? Is it possible to set the number of tries or the waiting time through the Postgre SQL code?
  2. What commands do you use to create a Database in Oracle 10g Express Edition?
  3. What are the differences between NUMBER datatype, BINARY_FLOAT datatype and BINARY_DOUBLE datatype?
  4. I already have a database in postgresql. I use the phpPgAdmin web-based GUI tool to access the postgresql database. Now, I need to migrate this postgresql database to oracle database. What migration tool is free of charge or has a trial period for this purpose. After, migration, I think I can use the Oracle's SQL Developer Tool to access the data within the Oracle Database for a trial period of 30 days.
  5. Hello, Is there a free downloadable postgresql to oracle migration tool? Thanks in advance!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.