Stack Overflow
Stack Overflow

Questions tagged [plsqldeveloper]

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.

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.

Home page: http://www.allroundautomations.com/plsqldev.html

PL/SQL Developer should not be confused with Oracle's SQL Developer: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

1591 questions
2
votes
1 answer

Find all child nodes for any parent node in Oracle 10g

My table structure is: COMPANY_ID, ID, PARENT_ID Here is some part from this table: | COMPANY_ID | ID | PARENT_DID | |------------|-------------|-------------| | 12 | 1 | null | | 12 | …
Ezio Auditore da Firenze
  • 1,186
  • 13
  • 18
2
votes
1 answer

Is that possible the copy all table on same schema in plsql

Is that possible to write copy all table include (data ,pk , fk .....) scripts on same schema with all object ? When I run the code below create table testmember as (select * from member); I can only bring table data . When i executed this code i…
rusty1119
  • 41
  • 1
  • 2
  • 5
2
votes
2 answers

Execute immediate error in Oracle

I want to execute the following command through a cursor where I have column name and column values in a different table. However the script fails with following error message. ORA-00933: SQL command not properly ended execute immediate 'UPDATE…
user3494938
  • 57
  • 1
  • 4
  • 13
2
votes
1 answer

Select from dual as one row?

To select many strings from dual as one column. I have tried the solution below and i can live with it, its relatively easy with PL/SQL macros to add "select from dual". I'm wondering is there any other way to achive this? select 'AAA' as code …
Ali Arda Orhan
  • 764
  • 2
  • 9
  • 24
2
votes
1 answer

PL/SQL developer (allroundautomations.com) hangs while compiling Package Body

i am using PL/SQL developer by allroundautomations. Some days back i was able to create package and package body. i did recompiled several times package body. But since yesterday, i am facing this issue. I open package body and click on recompile…
Sam4Code
  • 541
  • 5
  • 9
2
votes
1 answer

How to retrieve column name and its value from cursor

Is there any way to get each column name and column value of each row using cursor. As below, i have a Cursor c loop through each row of table T FOR c IN (SELECT * T) LOOP --Something like dbms_output.put_line(c.columname : c.columnvalue);…
user2090487
  • 107
  • 1
  • 3
  • 7
2
votes
1 answer

Does an insert statement's FROM clause support parameters?

I have a select like this: insert into F (fil) select count(*) from teste teste isn't a table. It's a parameter captured in another select that gets the name of the table destined for the FROM. but the script exit said this error mesage: table or…
otoniel.cantillo
  • 19
  • 4
2
votes
2 answers

Wrapping a Stored Procedure

I have created a Stored Procedure in Oracle (Via TOAD). I need to deliver this procedure to some other developers. All is need to do is Wrap the procedure so that at basic level he/she should not be able to view the code. At the same time, the…
ShobhitSaxena
  • 73
  • 5
  • 12
2
votes
1 answer

Test Scripts for PL/SQL Stored Procs

With TSQL I'm used to putting some repeatable tests in for my stored procs. Typically this may include putting the db in a particular state, runnings the sproc, validating the state and rolling back. And contrived example might something like…
Karl Kieninger
  • 8,841
  • 2
  • 33
  • 49
2
votes
1 answer

Find all objects inside a Package or Stored proc

I'm not sure if this question make sense. But thought of asking this here. Assume I have procedure like below, CREATE OR REPLACE PROCEDURE PROCEDURE1 AS BEGIN SELECT COLA INTO COL **Payment**.TAB1 ; SELECT COLA INTO COL **Checkout**.TAB1 ; END…
Prabhu
  • 115
  • 9
2
votes
1 answer

Extract ddl for alter statement in oracle

I'm working on an automation to generate the ddl automatically. Ofcourse I'm using DBMS_METADATA.GET_DDL to get the same. It works fine. Now I need help on the following. Assume TableA is already there in the database with three column COLA,COLB &…
Prabhu
  • 115
  • 9
2
votes
2 answers

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 as well? While is := used for variable initialization, can it be used for assignment too? Then, so what is the difference between the use of…
Yue Harriet Huang
  • 3,969
  • 6
  • 17
  • 16
2
votes
3 answers

In PL/SQL, how do I use a varaible in a SELECT *without* using an INTO?

I'm experimenting with queries in an Oracle database (Using Oracle SQl Developer and PL/SQL Developer) If I run a simple query: (SELECT * FROM myTable WHERE id = 1234) the results display in a nice grid in a lower pane of the SQL tool. Now, how do I…
James Curran
  • 101,701
  • 37
  • 181
  • 258
2
votes
1 answer

Please explain me the query attached

Folks, Can someone please help me to explain the below query? SELECT SOME_ID ROOT_CAT, CHILD_ID SOME_ID FROM CHILD_TABLE START WITH SOME_ID IN (SELECT ROOT_ID FROM ROOT_TABLE) CONNECT BY NOCYCLE SOME_ID = PRIOR CHILD_ID;
Prabhu
  • 115
  • 9
2
votes
0 answers

Oracle UTL_HTTP POST encoding multipart/form-data

I would like to do a POST from PL/SQL, using as enctype "Multipart/form-data" in order to post a document contained in a LONG RAW to a servlet. This would simulate a typical "FILE UPLOAD" as if done by a browser. I was wondering if there is any…
Winter
  • 1,896
  • 4
  • 32
  • 41
1 2 3
…
99 100