Prerequisites An understanding of Autonomous Database and Database Actions Page. After you have successfully connected to MSSQL Server using SQL Developer, you can open the query window and execute commands.
Uncategorized
Posted on:
SQL History
V$SQL view has the following column and statistics data. select sql_txt from v$sql select s.username, s.sid, s.serial#,t.sql_text “Last SQL”from gv$session s, gv$sqlarea twhere s.sql_address =t.address ands.sql_hash_value =t.hash_value
Uncategorized
Posted on:
Oracle DB Client Installation
Go to Oracle Linux x86-64 instant clients download page Download the matching client Install Set environment variables in your ~/.bash_profile Reload your .bash_profile by simply typing source ~/.bash_profile (suggested by jbass) or Log-out user and […]
