Can we enter data in a table in design view?
No Answer is Posted For this Question
Be the First to Post Answer
Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... create or replace trigger trg_sun before insert on <table name> begin if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then raise_application_error(-20345,'no transaction in sunday'); end if; end trg_sun;
What are the differences between in and exists clause?
How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 Answers IBM, TCS, UHD,
What are local and global variables and their differences?
What is case function?
How to prepare for oracle pl sql certification?
List the different type of joins?
How do I make my sql query run faster?
Is sql a programming?
Describe different types of general function used in sql?
Explain the concept of normalization.
What is database sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)