Query
select
abs(to_number(to_char(to_date('&FromDT_dd_mon_yyyy','dd-mon-yyyy'),
'WW'))
2* -
to_number(to_char(to_date('&ToDT_dd_mon_yyyy','dd-mon-yyyy'),'WW')) ) "Number
of weeks" from dual
Database Connection Using SQLPLUS Without tnsnames.ora from Command Line
Here is the method to connect to the oracle database using sqlplus
without configuring the TNSNAMES from the OS prompt.
Syntax: sqlplus
username/password@Host_name:Listener_port/database_Service_name
Where you must know the username and password for the database.
You can use following options to find out the hostname, Listener port and
database service name
digitizeindia.gov.in: What is the Reward Point Conversion rate / Value in Rupee or Paise?
Digitizeindia.gov.in is the one of the trustworthy
Indian government website for the online money making through data entry. But
one of the major concern which I face is the slowness of the website. Most of
the time the website is utter slow to load the snippets. Your patience is
important for this activity at least for these initial days J.
digitizeindia.gov.in: Snippets have exhausted. Please try again later
Digitizeindia.gov.in is the one of the trustworthy
Indian government website for the online money making through data entry. It
works based on the online data entry work. The snippets are the scanned
documents from the different government organizations. Most of the time you
will get enough snippets for the data entry. But at least some days or during
particular time you may face the following pop up with message “Snippets
have exhausted. Please try again later”
2 Ways to Run / Execute OS (Unix, Linux, Windows) Commands, Shell Script from SQLPLUS or SQL prompt
OS Commands Execution
You can use
either ! or host keyword to execute OS commands
or to run shell script from the sqlplus / sql prompt.
Here are
some examples for OS command execution
SQL> !pwd
/home/oracle
SQL> host
pwd
/home/oracle
Fix Oracleasm Deletedisk Command Failed with Unable to Clear Disk “Disk Name”
Error Description
Oracleasm
deletedisk diskname failed with following error
# oracleasm deletedisk OCR_VOTE
Clearing
disk header: failed
Unable
to clear disk "OCR_VOTE"
Oracle 12c Data Redaction (Full, Partial, Random, Regular Expression) Implementation Examples
Let’s first
create a sample test table 'TEST_DATA' under REDACT schema.
SQL> grant EXECUTE ON sys.dbms_redact TO REDACT;
Grant succeeded.
SQL> grant connect, resource to REDACT;
Grant succeeded.
Sample table created with following data
