Top "Plsqldeveloper" questions

PL/SQL Developer is an Integrated Development Environment by Allround Automations that is specifically targeted at the development of stored program units for Oracle Databases.

Unable to log-in using PL/SQL Developer

I have problem with logging into my database using Pl/SQL Developer. All connection parameters are defined in TNSNAMES.ORA …

oracle plsqldeveloper
PL SQL Auto Commit on execution

I am very new to the PL/SQL programming. I tried to write a pl/sql procedure with some DML …

plsql plsqldeveloper
How to keep alive the connection in PL/SQL Developer?

I am using PL/SQL Developer 11.0.4.1774. In my work, I need to use database whole day. Sometimes, during 30-60 minutes, …

oracle session time plsqldeveloper
How do I check index building status on Oracle 11?

I made terrible mistake in SQL index creation: create index IDX_DATA_TABLE_CUSECO on DATA_TABLE (CUSTOMER_ID, SESSION_…

oracle plsql oracle11g indexing plsqldeveloper
using define statement in PL/SQL developer

This is one of the tasks from my homework assignement: DEFINE countryid = CA DECLARE country_record countries%ROWTYPE; BEGIN SELECT * …

sql oracle plsqldeveloper psql
What is the difference between := and = in Oracle PL/SQL

I want to know in Oracle PL/SQL, = can be used for Boolean comparison, can it be used for assignment …

plsql oracle11g plsqldeveloper colon-equals
PL/SQL send email with attachment?

we have a table with files saved as BLOB I write a code that email these files as an attachment! …

oracle plsql smtp plsqldeveloper
How to exit the loop in oracle

Declare var_cnt number(3):=0; begin loop update t_loan_dtl set loan_closure = 'Y' where rownum <10001; end loop; end;

plsql plsqldeveloper
How to check activity log of Oracle SQL Developer

I want to monitor Activity Logs on Oracle SQL Developer Tool, using F8 key i am getting SQL history. I …

oracle11g oracle-sqldeveloper plsqldeveloper
What is the meaning of Cost, Cardinality and Bytes in Explain Plan?

This is a simple query: select * from customers When I write this query in PL/SQL Developer and press F5, …

oracle plsqldeveloper sql-tuning