Loading...

Hey guys so at work I've been task to make a VM for some classes at the School I work for. Pretty much I have to make a VM that has SQL developer which I was able to get started with no issues. The thing I'm struggling with is installing and getting is SQL*PLUS running and make it be able to use Scott/Tiger. I was able to get everything installed but every I try to log in with Scott/tiger i get the following error: "ORA-12560: TNS:protocol adapter error. I did the install the normal way just followed the prompts and what not. The sole purpose for this VM is so students can get to the Scott/Tiger tables and just use that and learn basics.

submitted by /u/caeloalex
[visit reddit] [comments]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Reddit - Oracle by /u/zulu1979 - 1w ago

Last week we suffered block corruption, and other issues in one of our reporting databases. Long story short I had to spin up a new server. I'm looking a tools to purchase in order to nip problems like this in the bud. What tools do you guys use to monitor your databases?

submitted by /u/zulu1979
[visit reddit] [comments]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Reddit - Oracle by /u/mylastgamble - 1w ago

Hey everyone! I’m trying to bring unit testing into my work and have hit a little roadblock. The client I do Oracle/PLSQL work for provided me with SQL Developer Vs 1.5 running oracle 11g and as far as I can tell unit testing isn’t available in that version of SQL developer. I’m also restricted so I can’t use any unit test platform that requires me to create new users or grant privileges.

Am I out of luck? Or is there something available that I can download and use that doesn’t require a purchase (as I don’t have the authority to purchase anything). Thanks!

submitted by /u/MyLastGamble
[visit reddit] [comments]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hey everyone,

I am a sql developer who works primarily in Oracle (i do a few odd jobs in MS SQL Server for another client) and I want to get better at what I do.

When I took my job here I had no experience in SQL other than teaching myself SQL and doing a few small reports at my last position. 2 years in, I've learned a lot but I want to learn more. I want to get better at both designing database structures as well as writing code, performance tuning, etc etc.

Any tips on where to go from here? Things I can do outside of work to increase my skills?

I thought about picking up a copy of this book for reference: https://www.amazon.com/Relational-Database-Design-Implementation-Fourth/dp/0128043997/ref=sr_1_1?ie=UTF8&qid=1525964189&sr=8-1&keywords=relational+database+design+and+implementation+by+jan+l+harrington

I didn't know if there was anything else I could do to help with problem solving or overall work? I just want to get better to be a better asset to my company (and my future)

Thanks! -Chris

submitted by /u/MyLastGamble
[visit reddit] [comments]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

I'm using the Oracle format mask on a field to output a value exceeding a million. Whenever I output the BI with xml data, I'll always get an exponential value. I tried this on version PeopleTools 8.54. But the same BI, whenever I run it on 8.55, I'll get the right amount. Can someone clarify this for me, please. Thanks.

submitted by /u/TaysiirG
[visit reddit] [comments]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Reddit - Oracle by /u/jorden789 - 1w ago

Hi All,

I have been looking at incorporating TDD into my workflow and seeing the benefits with PyUnit.

Are there any libraries for PLSQL development or would it be a case of writing specific procedures/functions to cater for this in a stand alone script?

submitted by /u/jorden789
[visit reddit] [comments]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

I cannot for the life of me understand how to do this with a recursive CTE.

I can do this with Cursor LOOP, but I'd like to implement this using only SQL rather than in PL/SQL.

The logic goes like this with PL/SQL goes like this:

DECLARE CLOB_LENGTH INTEGER; SUBSTR_START INTEGER := 1; SUBSTR_NEXT INTEGER := 4000; CLOB_CODE CLOB; TEMP_VARCHAR VARCHAR2(32767); BEGIN SELECT DBMS_LOB.getlength(CLOB_COLUMN), CLOB_COLUMN INTO CLOB_LENGTH, CLOB_CODE FROM CLOB_TABLE WHERE ROWNUM = 1; WHILE SUBSTR_START <= CLOB_LENGTH LOOP TEMP_VARCHAR := DBMS_LOB.SUBSTR(CLOB_CODE, SUBSTR_NEXT, SUBSTR_START); DBMS_OUTPUT.PUT_LINE(TEMP_VARCHAR); SUBSTR_START := SUBSTR_START + 4000; SUBSTR_NEXT := SUBSTR_NEXT + 4000; END LOOP; END; 

Anybody know how to do this using a Recursive CTE?

submitted by /u/_Zer0_Cool_
[visit reddit] [comments]
Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview