Monday, April 12, 2021

Oracle Database sqlcl basics

 Need to connect to an oracle database?


Download Oracle SQLcl


https://www.oracle.com/tools/downloads/sqlcl-downloads.html


Extract the zip


Login using this command


> SQL username@//server:1521/databasename


Show what user you are

SQL> show user


Now check what version of oracle you're on

SQL>  select BANNER from v$version;


Display the instance you're on

SQL> select INSTANCE_NAME, HOST_NAME, VERSION from v$instance;


Check what database you're connected to

SQL> select name from V$database;


List all user accounts

SQL> select * from all_users;



5 comments:

  1. Are you in need of finance? we give out guarantee cash at 3% interest rate. Contact us on any kind of finance now: financialserviceoffer876@gmail.com whatsapp Number +918929509036 Dr James Eric Finance Pvt Ltd

    ReplyDelete
  2. I was thrown out of my own house was sleeping in a hotel for weeks she also took possession of my son could only see him once a week then I found out she was in love with my accountant all these while so I went online and I came across a Russian private investigator who help me get all my properties and my accounts back even my company back how he did these I don’t know but I gave all the information he asked for and followed all his instructions and now I’m happy my life’s better now.
    Thanks to HACKINTECHNOLOGY@CYBERSERVICES.COM
    I just said I should share my own story here
    Thank you

    ReplyDelete
  3. I know of a group of private investigators who can help you with they are also hackers but prefer to be called private investigators They can help with your bitcoin issues and your clients will be happy doing business with you,they can also help yo with your bad credit score,hacking into phones,binary recovery,wiping criminal records,increase school score, stolen files in your office or school,blank atm etc. Just name it and you will live a better life
    Contact +1(407) 777-4240
    Premiumhackservices@gmail.com

    ReplyDelete
  4. He is the best out there,I tested him and he delivered a good job,he helped me settle bank loans,he also helped my son upgrade his scores at high school final year which made him graduate successfully and he gave my son free scholarship into the college,all I had to do was to settle the bills for the tools on the job,I used $500 to get a job of $50000 done all thanks to Robertson he saved me from all my troubles,sharing this is how I can show gratitude in return for all he has done for me and my family

    Contact premiumhackservices@gmail.com

    Text/call ‪+1 (984) 733‑3673‬

    WhatsApp ‪+1 (984) 733‑3673‬

    Telegram ‪+1 (984) 733‑3673‬

    ReplyDelete
  5. I was depressed some Months ago due to how frustrating it is dealing with bad credits, but reaching out to HACK VANISH via Phone: +1 (747) 293-8514 and Email: HACK VANISH (@) GMAIL. COM gave my life a new meaning, after I found him credible through positive reviews I read on a credit blog, in a twinkle of an eye, this great hacker got my credit score restored from 509 to 784 across the 3 major credit bureaus, all evictions and repossession has been wiped off, my LexisNexis and Chex system fixed respectively, to my greatest surprise, some days later, I received an E-mail confirming the approval of my pending loan application. I can confidently say 2021 was an exceptional year for my husband and I as we are proud owners of a new home and a brand-new SUV courtesy HACK VANISH, I would definitely recommend him to anyone in need of a genuine Hacker.

    ReplyDelete