python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - oracle-sqldeveloper

How to prevent Varchar Appending Duplicate Information

I'm learning PL/SQL stored functions in Oracle SQL Developer and I'm having trouble trying to create a function that returns a row that does not contain duplicate information. Schema information: APP...
test-img

Damon O'Neil

sql

plsql

oracle-sqldeveloper

stored-functions

Votes: 0

Answers: 1

Latest Answer

@OldProgrammer is right u can do it in one select statement. Here is my sample table and data: create table SPOSSESSED (sname varchar2(30), anumber number); create table sneeded (sname varchar2(30), p...
test-img

Toni Antunović

Update statement to change timestamp field add year to current values

I need to be able to update a specific column in a table that is a time stamp. Its an expirationdate column and I need to add 5 years to the values in that. For these specific ids that are set to expi...
test-img

Ryan Wills

sql

oracle-sqldeveloper

Votes: 0

Answers: 1

Latest Answer

I presume that expiration date doesn't actually contain fractional seconds; that's most probably truncated to day, so date datatype is date. If that's so, then add_months is one option: 5 (years) * 12...
test-img

Littlefoot

Debian - errors when converting Oracle SQL .rpm package to .deb using alien

I want to install Oracle SQL Developer on Debian. Oracle doesn't provide a .deb installation package, only a .rpm installer. So I'm trying to use alien to convert the .rpm package to .deb Some details...
test-img

MikeW

debian

oracle-sqldeveloper

alien

Votes: 0

Answers: 0

How to get table structure in oracle with constraints?

using DBMS_METADATA.GET_DDL('TABLE','PERSON') from DUAL is not working. how to get the meta details of whole schema?
test-img

Rajkumar D

oracle

oracle-sqldeveloper

Votes: 0

Answers: 1

Latest Answer

In SQL Developer, simply run ddl person We'll run the DBMS_METADATA pl/sql block for you. You can shape the DDL being generated by using the SET DDL command. Then you can see what we're doing down h...
test-img

thatjeffsmith

Posts

Questions

Blogs

Jobs