Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.
I'm trying to subtract date from Oracle so it even effect the day as well. For example, if the timestamp …
sql oracle date-arithmeticHow does one change the current directory in SQL Plus under windows. I am trying to write a script with …
oracle sqlplusI'm getting this error if i try to login as db user. If lsnrctl status is run i get the …
database oracle database-administrationNeed some help in converting numbers: select to_char(a, '99D99') , to_char(a, '90D99') from ( …
oracle to-char2 Separate questions. I am using this script to drop a table [SOLVED] BEGIN EXECUTE IMMEDIATE 'DROP TABLE_NAME'; DBMS_OUTPUT.…
oracle plsql ddl temp-tablesLets assume I have this sample data: | Name | ID | PARENT_ID | ----------------------------- | a1 | 1 | null | | b2 | 2 | null | | c3 | 3 | null | | a1.d4 | 4 | 1 | | …
sql database oracle plsql hierarchical-dataI am working with a query which contains "IF" statements within a "WHERE" clause. But PL\SQL Developer is giving …
oracle plsql plsqldeveloperThis information should be easy to find, but I haven't had any luck. When I have a BEGIN - END …
oracle plsqlI have a to compare dates in 2 tables but the problem is that one table has the date in DD-Mon-YY …
sql oracle date-format to-date