when loggined as SYSTEM,how to display all the users of database using sql query?
Answers were Sorted based on User's Feedback
What are the different types of partitions in oracle?
what is the syntax of DROP command?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Do View contain Data ?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
What are ACID properties in databases?
How to grant create session privilege to a user in oracle?
How to restrict the duplicate records in table valuesets
Hi Can any one tell me what are the API's used in requisition import.
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
what is host string in sql plus? how does it related to database?