Top "Plsql" questions

SQL recursive query on self referencing table (Oracle)

Lets assume I have this sample data: | Name | ID | PARENT_ID | ----------------------------- | a1 | 1 | null | | b2 | 2 | null | | c3 | 3 | null | | a1.d4 | 4 | 1 | | …

sql database oracle plsql hierarchical-data

If statement within Where clause

I am working with a query which contains "IF" statements within a "WHERE" clause. But PL\SQL Developer is giving …

oracle plsql plsqldeveloper

BEGIN - END block atomic transactions in PL/SQL

This information should be easy to find, but I haven't had any luck. When I have a BEGIN - END …

oracle plsql

Oracle PL/SQL string compare issue

I have the following Oracle PL/SQL codes that may be rusty from you guys perspective: DECLARE str1 varchar2(4000); str2 …

sql oracle plsql oracle10g oracle11g

ORA-12154: TNS:could not resolve the connect identifier specified (PLSQL Developer)

I need to use PLSQL Developer to access oracle databases. I get the following error when I try to connect …

oracle plsql sqlplus plsqldeveloper tnsnames

Splitting comma separated string in a PL/SQL stored proc

I've CSV string 100.01,200.02,300.03 which I need to pass to a PL/SQL stored procedure in Oracle. Inside the proc,I …

oracle plsql tokenize

Get counts of all tables in a schema

I am trying to get the record counts of all tables in a schema. I am having trouble writing the …

oracle plsql

How do you execute SQL from within a bash script?

I have some SQL scripts that I'm trying to automate. In the past I have used SQL*Plus, and called …

sql oracle bash plsql sqlplus

Evaluation of PL/SQL boolean variables in Oracle Forms

Suppose I have a BOOLEAN variable within a PL/SQL block in an Oracle Form: DECLARE is_viewable BOOLEAN; BEGIN …

oracle plsql boolean oracleforms

Execute stored procedure with parameters

I have stored procedure and should get its result. From debugging of Java part: return getJdbcTemplate().call(newCallableStatementCreator(inParams), getDeclaredParameters()); …

parameters plsql execute procedure