You are trying to order your result with columns that are not being calculated. This wouldn’t be a problem if you didn’t have the DISTINCT there, but since your query is basically grouping only by share.rooms column, how can it order that result set with other columns that can have multiple values for the same … Read more
Open command prompt and execute the below commands: set oracle_sid=DATABASE NAME sqlplus /nolog conn sys/sys as sysdba shutdown abort startup
If you want to add N days to your days. You can use the plus operator as follows – SELECT ( SYSDATE + N ) FROM DUAL;
You don’t need to create any stored types, you can evaluate Oracle’s built-in collection types. select distinct column_value from table(sys.odcinumberlist(1,1,2,3,3,4,4,5))
The difference is- A function must return a value (of any type) by default definition of it, whereas in case of a procedure you need to use parameters like OUT or IN OUT parameters to get the results. You can use a function in a normal SQL where as you cannot use a procedure in … Read more
One of the reasons of your problem could be the password policy you are using. And if there is no such policy of yours then check your settings for the password properties in the DEFAULT profile with the following query: SELECT resource_name, limit FROM dba_profiles WHERE profile=”DEFAULT” AND resource_type=”PASSWORD”; And If required, you just need … Read more
The user and password are DEFINITELY incorrect. Oracle 11g credentials are case sensitive. Try ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE; and alter password. http://oracle-base.com/articles/11g/case-sensitive-passwords-11gr1.php
I am not sure what you understand by “execute from the Command line interface”, but you’re probably looking after the following select statement: select * from dba_users; or select username from dba_users;
How was the database exported? If it was exported using exp and a full schema was exported, then Create the user: create user <username> identified by <password> default tablespace <tablespacename> quota unlimited on <tablespacename>; Grant the rights: grant connect, create session, imp_full_database to <username>; Start the import with imp: imp <username>/<password>@<hostname> file=<filename>.dmp log=<filename>.log full=y; If … Read more
Connect as SYSTEM. CREATE USER username IDENTIFIED BY apassword; GRANT CONNECT TO username; GRANT EXECUTE on schema.procedure TO username; You may also need to: GRANT SELECT [, INSERT] [, UPDATE] [, DELETE] on schema.table TO username; to whichever tables the procedure uses.