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
1
vote
1 answer

Inline Query to Procedure

How do i write a procedure for login query in .net : StringBuilder sql; sql = new StringBuilder("Select User From Login_user "); sql.Append(" Where User_Name_upper = '" + strUserName.ToString().ToUpper() + "'"); OracleCommand cmdUserDetails =…
rakesh
  • 13
  • 2
1
vote
3 answers

TRIGGER with INSERT AND UPDATE

I need help on creating a trigger on my table1 that will insert specific columns into table2 from table1. How can I do that? I am using Oracle 11G XE . Here is my code: create or replace trigger AllowanceTrigger after insert on ex_bulacan for each…
Michael Pilapil
  • 11
  • 2
  • 5
1
vote
1 answer

Oracle BLOB column reading

I have a result of a query which has BLOB column defined in it. The BLOB contains images and i am interested in showing this result to others without using any sort of application. e.g. the query return three columns:- NAME => Steven PHONE =>…
Femme Fatale
  • 870
  • 7
  • 27
  • 56
1
vote
2 answers

Whats wrong with this PLSQL code block

The code block below is not running when executed from a batch file. It just hangs (nothing happens). It sits there for hours. I am unable to track what the problem is or how to debug this. Please help. declare v_personrefid varchar2(50); v_hiredt…
ozzboy
  • 2,672
  • 8
  • 42
  • 69
1
vote
2 answers

Import and Export Data plus schema using SQLDeveloper 3.0.04

i am newbie to oracle and i like to export database from remote database and import it on local machine. eOn both machines i have oracle 10.2. I need to know how to export/import schema and data from oracle 10.2 using SQLDeveloper 3.0.0.4. To export…
Rehman
  • 3,908
  • 6
  • 28
  • 29
1
vote
1 answer

PL/SQL compilation error during update

Query DECLARE v_vendor_id NUMBER; BEGIN FOR vp_rec IN ( SELECT * FROM vpprocess ) LOOP SELECT i.vendor_id INTO v_vendor_id FROM item i, lineitems l WHERE l.itemid = i.itemid AND l.id = vp_rec.lineitemid; EXCEPTION …
Mad-D
  • 4,479
  • 18
  • 52
  • 93
1
vote
2 answers

Spacing reading from a String in SQL

I have a string (with spaces) from which i want to separate the last word. For example: "Steve Jobs" => Jobs "Stack OverFlow Question" => Questions Is there any function in PL/SQL or SQL so that i am able to get the results as Jobs and Question…
Femme Fatale
  • 870
  • 7
  • 27
  • 56
1
vote
2 answers

Cannot connect Oracle 32bit on X64 machine

I have installed the Oracle Client 10.2.1 32bit in an X64 WIN7 laptop. I have Installed also TOAD and PLSQLDeveloper but both of them are not working and the error is: ORA-12154:TNS could not resolved the connection idebrified. While with the NET…
ekekakos
  • 53
  • 1
  • 7
1
vote
1 answer

Can somebody verify this for me in sql or teradata

I have a line of code in Oracle and I had to convert it into Teradata. The Oracle query is /* add to avoid invalid number due to junk in column */ AND regexp_instr(table.column, ''[^[:digit:]]'', 1, 1) = 0 The code I have written in Teradata…
user708477
  • 147
  • 2
  • 4
  • 14
1
vote
0 answers

Oracle query to determine data sources (external and internal) for Tables and MViews in a schema?

So lets say I provide my customers a schema in Oracle on which they can access data {as views based on my table and its data (which is in another schema)} and also they use third party sources/connections to get more data for their tables, MViews…
Dante
  • 11
  • 1
1
vote
3 answers

CLOB variable gives "ORA-06502: PL/SQL: numeric or value error"

I'm creating a dynamic report on oracle apex. I've a very huge query and as per requirement any portion of the query can be returned. I'm using PL/SQL Function Body returning SQL query feature of IR. For that, I'm simply returning the output. Return…
Anand
  • 101
  • 13
1
vote
3 answers

Why do I set the time format, but still report an error

I try to insert data after I set the format, but I get a time format error ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY'; INSERT INTO EMP VALUES (7934, 'MILLER', 'CLERK', 7782, TO_DATE('23-JAN-1982', 'DD-MON-YYYY'), 1300, NULL,…
Shahana
  • 13
  • 3
1
vote
2 answers

How to return more than one select queries in same procedure

I would like to ask how can i print output in procedure more than one statement. Assume that you want to show dba_objects and segments row count. But i can not use dbms_sql.return_result my version is 11g. Something like, create or replace procedure…
microracle
  • 69
  • 1
  • 11
1
vote
0 answers

How insert data in table randomly by using for loop. ORA-06550

I have a table (base-info) with some columnslike(name, family ,gen, city ,age, job, id) that have data; Now I want to build a new table by base-info data's randomly and Ofcourse I want to use for loop & insert into valuse sysntax; I wrote the…
Hossein GH
  • 11
  • 3
1
vote
1 answer

Why Oracle prepend the Schema name to created procedures?

I'm connecting to a new Oracle database with Toad. If a create a procedure like: create or replace procedure MyProc... After I compile it, the name automatically is changed to SchemaName.MyProc This doesn't happen in other Oracle databases where…
Yuki NET
  • 11
  • 2
1 2 3
…
99 100