Basic queries which you need to know in the oracle

User Creation

In order to create a new user just run the below query





QUOTA 20M on DemoSpace;

The query is really self-explanatory and you can modify it as you wish.

Identified is used for creating the password.

Tablespace is basically a space on the disk only where all your objects like tables will be stored.

20M indicates the size of the space allotted to your tablespace.

The above query will refuse to run incase if there is no tablespace in the system. So you need to create the tablespace before executing the above query. Here is the query for the same. It is not a complete query. For that please consult official documentation.

Create tablespace spacename datafile ‘datafilename.dbf’ size 60m reuse extent management local

Also I was confused with the fact that how to store binary data in the oracle table. In the official help file it is written we can use varbinary and binary as the data types for storing binary data but they are not available in the express edition of the oracle. So in order to store the binary data in this edition we can use RAW type. The RAW type allow the storage of bytes of size up-to 4000 bytes.

How to know the version of oracle?
Select * from v$version where banner like ‘oracle%’

Unable to login with sysdba rights on windows.

Hi all of you,

Here I am going to share some of the Oracle based queries which can be helpful to someone who is just starting with Oracle.

Well, first question most of the times is that how to connect a user as a sysdba. Normally we try to login with the System user but you should know that System user does not have this kind of Privilege from the start. So in order to start using sysdba privileges login with the sys user and connect it as sysdba. Password is normally same for sys also.

Once you have login with this user you can assign sysdba role to another user also using the following query.

Grant SYSDBA to username

Happy new year 2015 to all the writers and readers of UB7.NET

2014 was a very quite year for UB7 as none of my staff (which includes me also) was proactive on this blog but i can assure you that we are not going out of the business any time sooner.

So as a come back gift UB7 will be updating this site more frequently with fresh content and also as new year gift we will be launching a new BF4 server in Asian location and this will be done very soon so just keep looking for in the BF4 server browser.


UB7 Admin

How to call an external function in Team Developer (Gupta Technologies)?

Well I have to say that this is really an obsolete piece of software but for helping others who are still stuck on this SOFTWARE 1 of my friend will be sharing some of the tips and tricks regarding this software.

I will be pasting the code into the text area below and in case you have any doubt, in that case you can get them clarified from him through the comments section below.

Continue reading “How to call an external function in Team Developer (Gupta Technologies)?” »