Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

select fields ?

Sergio Tancredi
Occasional Advisor

select fields ?

Hi all,

I need a sql command that allow me to see which
fields are locked on a specific table.

How can select?

Thanks in advance,
Sergio


3 REPLIES

Re: select fields ?

I suggest you speak to your database/application provider for this one.
My house is the bank's, my money the wife's, But my opinions belong to me, not HP!
Alexander M. Ermes
Honored Contributor

Re: select fields ?

Hi there.
What database is it ? If it is Oracle,
try 'desc tablename'. Or you can try to connect to that database with ODBC / MS-ACCESS
and link that table.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Sergio Tancredi
Occasional Advisor

Re: select fields ?

I've solved the problem with a reboot of Oracle DB.

I had an hanged transaction that blocked my system.

Thanks all,
Sergio