Home
Search results “Sysdate oracle trunc”
oracle date and time functions
 
21:33
Video from our Oracle SQL course. Check out the full course at.. http://learn.hackpress.co/courses/oracle-sql-learning-by-example
Views: 40264 etldeveloper
trunc(sysdate-1)
 
03:49
Views: 115 matthew naquin
trunc(sysdate -1)
 
03:50
video for the song trunc(sysdate -1) from the Foreign Key EP by San Mateo
Views: 21 San Mateo
Oracle SQL Video Tutorial 17 - TRUNC function
 
02:16
Oracle SQL Video Tutorials 17 - TRUNC function explained
Views: 3222 Just Channel
ORACLE SQL 22: SYSDATE
 
07:06
http://studyandshare.wordpress.com/ http://www.facebook.com/groups/studyandsharevn/
Views: 1388 studyandsharevn
2 13 SYSDATE vs CURRENT DATE
 
01:25
Oracle SQL SYSDATE vs CURRENT_DATE
Views: 195 Mahesh Peiris
Oracle - SQL - Date Functions
 
07:56
Oracle - SQL - Date Functions Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Working with dates in Oracle PLSQL.
 
23:34
Dates in Oracle PL SQL is definitely the most powerful among all other databases. It gives us full flexibility to manipulate it of our choice, whether you are calculating days, months or year, printing date and time in various format. Useful date functions add_months, months_between, last_day, next_day and to_char helps us a lot in handling date time in our pl sql programming.
Views: 4929 Subhroneel Ganguly
Funciones Oracle Upper, Lower, Inicap, Lentgh, Substr, To char
 
09:38
En esta leccion veremos como podemos utilizar las funciones basicas de Oracle para hacer las consultas. Siguenos en - http://www.aprendedesarrollo.com/
Views: 1602 Alejandro Alvarez
SYSDATE Function: SQL Tutorial 35
 
00:26
Please watch: "Install Oracle Database 12c Release 2 on Windows 10 Professional 64 bit" https://www.youtube.com/watch?v=5705VFJmku0 -~-~~-~~~-~~-~-
Views: 270 Solution Wizard
Oracle TO_NUMBER Function
 
02:42
https://www.databasestar.com/oracle-to_number/ The Oracle TO_NUMBER function is used to convert a text value into a number value. It’s similar to TO_CHAR and TO_DATE, but converts a value to a number. The number will also be rounded to a specified number of digits, and returned as a NUMBER value. The syntax is: TO_NUMBER( input_value, [format_mask], [nls_parameter] ) The input_value is the value to be converted to a number. Commonly this is provided as a string (e.g. CHAR or VARCAHR2) but can be several other data types as well. The format_mask is the format that the output value should be displayed as. It must be a valid number format. This is an optional value. The final parameter, nls_date_language, is used to work out how the output is displayed, such as how to display currency symbols. It’s also an optional value. For more information about the Oracle TO_NUMBER function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-to_number/
Views: 1691 Database Star
Oracle MONTHS_BETWEEN Function
 
02:17
https://www.databasestar.com/oracle-months_between/ The Oracle MONTHS_BETWEEN function allows you to find the number of months between two dates. You can enter two dates and the function returns the difference. This function is often used as part of other calculations. Sometimes you’ll want to know the difference between two dates to perform other functions. The syntax of the MONTHS_BETWEEN function is: MONTHS_BETWEEN(date1, date2) What do these two parameters mean? The function performs date1 minus date2. So, if date1 is larger, the result is positive. If date2 is larger, then the result is negative. What data type is returned? It depends on the values you provide. If the dates are both on the same day of the month (e.g. both on the 10th of the month), then the result is an integer or whole number. If not, then the result will be a decimal value. For more information on the MONTHS_BETWEEN function, including the code used in this video and examples, read the related article here: https://www.databasestar.com/oracle-months_between/
Views: 680 Database Star
Oracle SQL: Exploring Date Functions
 
07:29
http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT Oracle SQL: Exploring Date Functions is an excerpt from Oracle SQL LiveLessons Video Training -- 6+ Hours of Video -- Oracle SQL LiveLessons Video Training covers the basics of the Oracle SQL programming language. This course covers both Oracle standard SQL and the ANSI approved SQL that Oracle supports. The focus of the course is to give students working knowledge of the Oracle SQL language and at the conclusion of this course, students should be able to query the Oracle database. Description In this LiveLessons video course, Oracle ACE Director Dan Hotka will teach you how to use the SQL query language, interpret business questions into SQL code, and how to use Where clauses sub-queries, complex table join conditions, and how to create table objects and populate tables with data. Students will also learn how to access Oracle from Microsoft products such as Excel. In addition, they will learn how analytical SQL can be used for business analysis. This course will use both Toad and SQL Developer for SQL examples. About the Instructor Dan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming Fundamentals. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com. Skill Level Beginner Learn How To Use the SQL query language Interpret business questions into SQL code Understand Oracle standard SQL and ANSI SQL Work with Where clauses, sub-queries, and complex table join conditions Create table objects and populate these tables with data Access Oracle from Microsoft products such as Excel Use analytical SQL, useful for business analysts Who Should Take This Course Students who are new to SQL and want to learn Oracle SQL Course Requirements Basic knowledge of what is a database, especially RDBMS and what is a computer programming language http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT
Views: 4408 LiveLessons
Oracle ADD_MONTHS Function
 
03:15
https://www.databasestar.com/oracle-add_months/ The Oracle ADD_MONTHS allows you to add a specified number of months to a date value, and return the new date value. It’s great for performing calculations on dates, or date arithmetic, which can be hard in many different programming languages. The syntax of the ADD_MONTHS function is: ADD_MONTHS ( input_date, number_months ) The function returns a DATE value. The parameters of this function are: - input_date (mandatory): This is the starting date, or the date that you will add a number of months to. - number_months (mandatory): This is an integer value that represents the number of months to add to input_date. The input_date can be any datetime value, or even a character value that can be converted to a date. Also, the number_months can be any number value, or a character value that can be converted to a number. What if the number of days in the two months are different? For example, adding a month to Jan 31 could result in Feb 31, which does not exist. Well, in this case, Oracle would work out that the date does not exist, and use the last date of the month (e.g. Feb 28). You can also provide a negative value for ADD_MONTHS to subtract months from the specified date. For more information about the Oracle ADD_MONTHS function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-add_months/
Views: 294 Database Star
12-Oracle  Functions - Months_Between - Add_Months -Next_Day - Last_Day - Round - Trunc.avi
 
37:44
12-Arithmetic with Dates - Functions - Months_Between - Add_Months -Next_Day - Last_Day - Round - Trunc
Views: 1919 Adel Sabour
Oracle10g / Single Row Functions / Date Functions
 
18:54
دوال الصف الواحد للتأريخ وتشمل : SYSDATE, MONTHS_BETWEEN, ADD_MONTHS, LAST_DAY, ROUND, TRUNC
Views: 537 Saif Academy
aula 2399 Funções Numéricas round e trunc
 
09:59
Aqui mais de 2.700 vídeo aulas no site www.informaticon.com.br.Desenvolvido pelo professor Neri Aldoir Neitzke, pós-graduado em Desenvolvimento para Web, professor e coordenador do curso de Sistemas de Informação da Universidade Ulbra e proprietário da Informaticon, email [email protected] 0xx543329-5400 Carazinho-RS Brasil Obs.: No youtube.com, as video aulas não estão nítidas e apenas a metade das vídeo aulas estão aqui. Caso queira, posso enviar um dvd com centenas de vídeo aulas originais com alta qualidade, e você ainda vai receber todo o código fonte.
Views: 1158 Neri Neitzke
Introduccion al lenguaje SQL - Las funciones ROUND y TRUNC (25)
 
04:50
Seguimos con mas funciones de nuestra base de datos Oracle. Hoy es el turno de las funciones ROUND y TRUNC. Recuerda que puedes acceder a la tabla de contenidos del curso de SQL completo en http://cursodelenguajesql.blogspot.com
Views: 1904 Asteriscoo Mas
38. Date Functions - Add_Months, Last_Day, Months_Between, Next_Day, To_Date, New_Time in Oracle
 
07:53
In this video you will learn about Date Functions { Add_Months(), Last_Day(), Months_Between(), Next_Day(), To_Date(), New_Time() } in Oracle. Unlike other programming language Oracle also uses functions to perform common operations. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 17982 ITORIAN
Função Oracle ADD MONTHS
 
05:29
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função ADD_MONTHS no Oracle recebe 2 parâmetros, sendo o primeiro a data que vai ser manipula e o segundo um inteiro que pode ser positivo ou negativo referente a quantidade de meses que serão adicionados ou subtraídos. SELECT trunc(sysdate) AS Data_atual, add_months(trunc(sysdate), 5) AS ADD_MONTHS FROM dual; SELECT add_months(to_date('29/02/16', 'DD/MM/YY'),1) AS ADD_MONTHS FROM dual; SELECT add_months(to_date('28/02/17', 'DD/MM/YY'),1) AS ADD_MONTHS FROM dual; SELECT add_months(to_date('27/02/16', 'DD/MM/YY'),1) AS ADD_MONTHS FROM dual; SELECT trunc(sysdate) AS Data_atual, add_months(trunc(sysdate), -1) AS ADD_MONTHS FROM dual; https://www.youtube.com/playlist?list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 447 Aprenda PL/SQL
when checkpoint will occur in oracle database
 
14:13
How to check current_scn number of database? ============================================= select CURRENT_SCN from v$database; select dbms_flashback.get_system_change_number from dual; select timestamp_to_scn(sysdate) from dual; how to check datafile header scn number? ========================================= select name,CHECKPOINT_CHANGE# from v$datafile_header; when checkpoint will occur? ============================ alter system switch logfile; alter database begin backup; alter database end backup; alter system checkpoint;(manual checkpoint) shutdown immediate;(when the database is down) what will happen when checkpoint occurs? ========================================= scn of datafile header will update;
Views: 3103 Praveen Biyyapu
Função Oracle LAST DAY
 
03:51
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função LAST_DAY retorna o último dia do mês da data passada como parâmetro. SELECT trunc(sysdate) AS Data_atual, last_day(trunc(sysdate)) AS ultimo_dia_mes FROM dual; SELECT last_day(to_date('10/02/2016', 'DD/MM/YY')) AS ultimo_dia_mes FROM dual; SELECT hire_date, last_day(hire_date) AS Ultimo_dia_mes FROM hr.employees WHERE employee_id =114; https://www.youtube.com/playlist?list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 463 Aprenda PL/SQL
The DUAL TABLE in Oracle Database
 
01:56
The DUAL TABLE in Oracle Database
Views: 1207 Abe Samir's Academy
Oracle Sql: Lecture 49: DUAL What is this
 
02:38
DUAL What is this https://www.youtube.com/channel/UCnBpiBIOtRgMsk4G7Ri1jbQ
Views: 1713 Oracle SQL
Oracle ROUND: Number function
 
03:48
Oracle TRUNC: Number function https://www.youtube.com/watch?time_continue=3&v=4lchx4sseEM Oracle MOD: Number function https://www.youtube.com/watch?v=eMGgo_1y6b4&feature=youtu.be The usage of SELECT Playlist: https://www.youtube.com/watch?v=ZwgiIiD1dWE&list=PLjBraywgeSpEW2f7AK4Ddt6BRxW0HWN74
SQL, Oracle, Dual table, 3e62
 
07:37
Understanding Dual table. Most SQL videos are available on www.my-uni.net also. Feel free to visit
Views: 2664 hammadshams
Introduccion al lenguaje SQL - Las funciones SYSDATE, MONTHS BETWEEN y otras (27)
 
02:29
En el curso de sql gratuito hoy es el turno de las funciones SYSDATE, MONTHS BETWEEN, ADD_MONTHS, NEXT_DAY y LAST_DAY. Todo el contenido del curso de lenguaje SQL para bases de datos Oracle está disponible en http://cursodelenguajesql.blogspot.com
Views: 1200 Asteriscoo Mas
Curso Oracle Sql - Video 19 - Funciones de Fila
 
07:30
Funciones de Fila: Caracter: TRANSLATE. SUBSTR. INSTR. UPPER. LOWER. Numéricas: ROUND. TRUNC. Fecha: SYSDATE. CURRENT_DATE.
ORACLE SQL 21: LOWER, UPPER, CONCAT, INITCAP
 
05:51
http://studyandshare.wordpress.com/ http://www.facebook.com/groups/studyandsharevn/
Views: 709 studyandsharevn
Oracle SQL Developer Tutorial For Beginners   95   Concatenation
 
02:20
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 540 Sam Dhanasekaran
Hướng Dẫn Lập Trình ORACLE SQL bài 22   Câu lệnh  SYSDATE
 
07:06
Video Hướng dẫn này được mình sưu tầm trên mạng và mong muốn chia sẻ kiến thức đến mọi người 1 cách tốt nhất. Mọi người có thể vào trang blog của mình để đảm bảo cho các bạn nhận được những video của mình đã sưu tập 1 cách tốt nhất và chất lượng nhất Mọi người truy cập tại: http://laptrinhoracle.blogspot.com/ để xem đầy đủ video hướng dẫn Các từ khóa bạn tìm kiếm trên google: Video hướng dẫn lập trình oracle hướng dẫn lập trình oracle Lập trình oracle blogspot Lập trình oracle blog hướng dẫn cài đặt oracle blogspot Video hướng dẫn lập trình oracle blogspot
Views: 414 Hau Van
ORACLE SQL 24: NEXT_DAY, LAST_DAY
 
05:16
http://studyandshare.wordpress.com/ http://www.facebook.com/groups/studyandsharevn/
Views: 723 studyandsharevn
Objetos oracle
 
04:52
creacion de tipos colecciones y objetos mediante base de datos oracle con interfaz pl/sql en windows 7 con maquina virtual virtualVox lo siento por la calidad del video en un proximo video lo mejorare el codigo del video esta a continuacion..!! CREACION DE UN OBJETO CREATE OR REPLACE TYPE ob_persona AS OBJECT ( cedula VARCHAR2(10), apellido VARCHAR2(50), fechaNac DATE, MEMBER FUNCTION edad RETURN NUMBER); UTILIZACION DEL OBJETO CREATE TABLE empleados ( cargo VARCHAR2(40), sueldo number(6,2), persona_ob ob_persona ); CREATE TABLE empleados OF ob_persona (cedula PRIMARY KEY ); SELECT e. persona_ob.edad() FROM empleados e; CREATE OR REPLACE TYPE BODY ob_persona AS MEMBER FUNCTION edad RETURN NUMBER AS BEGIN RETURN Trunc(Months_Between(Sysdate, fechaNac)/12); END edad; END CREATE OR REPLACE TYPE T_Computadora AS OBJECT ( S_operativo VARCHAR2(10), color VARCHAR2(25), caracteristica VARCHAR2(50)) / CREATE OR REPLACE TYPE T_Personas AS OBJECT ( Nombre VARCHAR2(25), Sexo varchar(2) Compu T_Computadora) / CREATE TABLE EMPLEADO OF Tipo_Persona; INSERT INTO EMPLEADO VALUES ('Ramón Ramirez', 'M', T_Computadora('XP', 'NEGRO', 'CORE I3')); CREATE TYPE lista_telefonica AS VARRAY(10) OF VARCHAR2(20) ; CREATE TYPE empleado_t AS OBJECT ( empnum NUMBER, empnom VARCHAR2(200), direccion direccion_t, lista_tel lista_telefonica ); CREATE TYPE linea_t AS OBJECT ( linum NUMBER, item VARCHAR2(30), cantidad NUMBER, descuento NUMBER(6,2) ) ; CREATE TYPE ordenes_t AS OBJECT ( ordnum NUMBER, cliente REF empleado_t, fechpedido DATE, fechentrega DATE, pedido lineas_pedido_t, direcentrega direccion_t ) ; lineas_pedido_t. CREATE TABLE ordenes_tab OF ordenes_t (ordnum PRIMARY KEY, SCOPE FOR (cliente) IS empleado_tab) NESTED TABLE pedido STORE AS pedidos_tab ;
Views: 1052 Digit System
ORACLE SQL 22  SYSDATE   YouTube
 
07:06
Chào các bạn, Blog StudyAndShare được xây dựng với mục đích chia sẻ kiến thức giữa cộng động những người yêu thích Công Nghệ Thông Tin Việt Nam. Nó hoàn toàn miễn phí với tất cả mọi người. Hi vọng Blog sẽ có ích cho công việc và học tập của các bạn. Channel https://www.youtube.com/user/studyandshare2012 sẽ là kênh chính thức của Blog từ 2012. Để xem thêm các tài liệu cũng như chia sẻ kiến thức và ý kiến xây dựng Blog, các bạn có thể gửi về các địa chỉ dưới đây: Blog: http://studyandshare.wordpress.com/ Facebook Group: http://www.facebook.com/groups/studyandsharevn/ Email: [email protected] Cảm ơn tất cả các bạn. Vì một Việt Nam tươi đẹp! Nhóm Blog Study And Share.
Views: 468 Study And Share
Oracle tutorial : Autonomous Transactions in Oracle 11g PL SQL-PRAGMA
 
10:40
Oracle tutorial : Autonomous Transactions in Oracle 11g PL SQL-PRAGMA What is pragma autonomous_transaction An autonomous transaction is an independent transaction to the main or parent transaction. If an Autonomous transaction is started by another transaction it is not nested, but independent of parent transaction. PRAGMA autonomous_transaction 1)In Oracle session, all of the changes made to data are part of a single transaction. 2)An autonomous transaction is an independent transaction started within another transaction (the main transaction). 3)Autonomous transactions allow you to temporarily suspend the main transaction, perform additional SQL operations, commit or rollback those operations separately, then resume the main transaction. 4)To define an autonomous transaction, we can use a PRAGMA statement PRAGMA AUTONOMOUS_TRANSACTION; CREATE TABLE log_data ( empno NUMBER(6), userid VARCHAR2(30), create_date DATE ); CREATE OR REPLACE TRIGGER add_log BEFORE INSERT OR UPDATE ON employee FOR EACH ROW DECLARE PRAGMA AUTONOMOUS_TRANSACTION; — This statement made this autonomous this trigger BEGIN INSERT INTO log_data VALUES (:new.id, USER, SYSDATE); COMMIT; END; / Insert into EMPLOYEE (ID, NAME, CITY, SALARY, DEPT_NO) Values (20, ‘MY Tech Query’, ‘Mumbai’, 20000, 1) ROLLBACK; SELECT * FROM EMPLOYEE SELECT * FROM LOG_DATA https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 2431 Tech Query Pond
Урок 33. SQL. Работа с датами.
 
10:41
В языке SQL Oracle диалекта существует множество функций для работы c типом date Напоминаю тип date содержит дату и время, например, время заполнения накладной , дату время создания записи в таблице Функция SYSDATE- текущая дата время если мы SYSDATE-1 предыдущий день, то же самое время SYSDATE-1/24*3 текущее время - 3 часа назад то есть единица обозначет сутки , а 1/24 один час учебная среда https://apex.oracle.com/pls/apex/ схема: SQLADV польз: student1 пароль: student1 будут работать (student2/ student2, student3/ student3 .... student11/ student11) меню SQL Workshop , SQL Command или используйте http://sqlfiddle.com/ скрипт бд для загрузки в sqlfiddle http://sqladv.ru/dev/sql.txt урок и задания http://sqladv.ru/dev/sqlbasic/l33.txt
Learn SQL: Query 4: Working with DATES
 
02:01
Dataset: http://www.ishelp.info/sites/yt/gsdb.accdb Next video: https://www.youtube.com/watch?v=adQR-EY6v2s&index=4&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Previous video: https://www.youtube.com/watch?v=Mztp1M5FUN4&index=2&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Topic: Learn Structured Query Language ( SQL ) keywords SELECT FROM WHERE topic DATES
Views: 1750 Mark Keith
PART-2 (Oracle Functions) Oracle PL SQL Training - Fast Track Series
 
26:20
Topic 2: Functions in PL SQL. In oracle there are two types of functions available. 1. Oracle Supplied Function (Built in Functions) Scaler Functions a) String Functions Length, instr, substr, rtrim, ltrim, lower, upper, concat, replace sqlplus sanket/patel SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 14 11:38:56 2017 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production SQL# SQL# select length('sanket') from dual; LENGTH('SANKET') ---------------- 6 SQL# select instr('sanket','n') from dual; INSTR('SANKET','N') ------------------- 3 SQL# select substr('sanket',1,3) from dual; SUB --- san SQL# select ltrim(' sanket ') from dual; LTRIM('S -------- sanket SQL# select rtrim(' sanket ') from dual; RTRIM('S -------- sanket SQL# select trim(' sanket ') from dual; TRIM(' ------ sanket SQL# select lower('SanKet') from dual; LOWER( ------ sanket SQL# select upper('SanKet') from dual; UPPER( ------ SANKET SQL# select concat('sanket','patel') from dual; CONCAT('SAN ----------- sanketpatel SQL# SQL# select replace('patel','e','i') from dual; REPLA ----- patil SQL# b) Date Functions Sysdate, add_months, extract, last_day, next_day, months_between c) Numeric Functions Trunc, ceil, round d) Oracle Type Cast or Conversion Functions To_char, to_date, to_number e) Null functions Nvl, Nvl2 Aggregate Functions Count,min,max,sum 2. User Defined Functions (PL SQL) CREATE [OR REPLACE] FUNCTION function_name [ (parameter [,parameter]) ] RETURN return_datatype IS | AS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [function_name]; Characteristics of Functions • Function must returns some value • Function can be called from select statement • Function support all three types of parameters available in oracle like IN, OUT and IN OUT parameters. Types of Parameters: IN Parameter: We can’t overwrite value of such kind of parameters. It is used to pass reference values to program and utilized it within the programs or sub-programs or other standalone programs. OUT Parameter: We can overwrite value of such kind of parameters. It is not useful to pass reference values to program and utilized it within the programs or sub-programs or other standalone programs but output value must need to be hold by calling program. IN OUT Parameter: We can overwrite value as well as pass reference value to program or sub-programs or other standalone programs but output value must need to be hold by calling program. EXAMPLES: --FUNCTION WITH OUT PARAMETER CREATE OR REPLACE FUNCTION GET_DATE_HH24TIME RETURN VARCHAR2 IS HH24DATE_TIME VARCHAR2(20); BEGIN HH24DATE_TIME := TO_CHAR(SYSDATE,'DD/MM/YYYY HH24:MI:SS'); RETURN HH24DATE_TIME; END; / --FUNCTION WITH PARAMETER CREATE OR REPLACE FUNCTION GET_P_DATE_HH24TIME (P_HH24DATE_TIME IN DATE) RETURN VARCHAR2 IS HH24DATE_TIME VARCHAR2(20); BEGIN HH24DATE_TIME := TO_CHAR(P_HH24DATE_TIME,'DD/MM/YYYY HH24:MI:SS'); RETURN HH24DATE_TIME; END; / SELECT GET_P_DATE_HH24TIME(SYSDATE) FROM DUAL; Drop Functions: We can drop function from the database. DROP FUNCTION GET_P_DATE_HH24TIME; SQL# SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE = 'FUNCTION'; OBJECT_NAME --------------------------------------------------------------------------GET_DATE_HH24TIME GET_P_DATE_HH24TIME DROP FUNCTION GET_DATE_HH24TIME;
Views: 4713 Sanket Patel
ORACLE: How to get FIRST and LAST day of a month ?
 
00:56
ORACLE DATE FUNCTION - trunc(date) - last_day()
Views: 324 1Click2beDBA
Can we drop the dual table?
 
12:29
This video deals with how to delete the dual table and the consequences that we might face if we delete the table.
Views: 441 Manoj Chakravarthy
ORACLE SQL 35 Truncate   Drop Table   YouTube
 
03:22
Chào các bạn, Blog StudyAndShare được xây dựng với mục đích chia sẻ kiến thức giữa cộng động những người yêu thích Công Nghệ Thông Tin Việt Nam. Nó hoàn toàn miễn phí với tất cả mọi người. Hi vọng Blog sẽ có ích cho công việc và học tập của các bạn. Channel https://www.youtube.com/user/studyandshare2012 sẽ là kênh chính thức của Blog từ 2012. Để xem thêm các tài liệu cũng như chia sẻ kiến thức và ý kiến xây dựng Blog, các bạn có thể gửi về các địa chỉ dưới đây: Blog: http://studyandshare.wordpress.com/ Facebook Group: http://www.facebook.com/groups/studyandsharevn/ Email: [email protected] Cảm ơn tất cả các bạn. Vì một Việt Nam tươi đẹp! Nhóm Blog Study And Share.
Views: 409 Study And Share
Curso Oracle Sql - Video 04 - Operadores Aritmeticos
 
04:28
Uso de operadores aritméticos. Uso de tabla de sistema Dual. Pseudocolumnas Sysdate y User. Buenas prácticas al realizar cálculos.
aula 2393 Personalizando Data e Hora com SYSDATE
 
07:48
Aqui mais de 2.700 vídeo aulas no site www.informaticon.com.br.Desenvolvido pelo professor Neri Aldoir Neitzke, pós-graduado em Desenvolvimento para Web, professor e coordenador do curso de Sistemas de Informação da Universidade Ulbra e proprietário da Informaticon, email [email protected] 0xx543329-5400 Carazinho-RS Brasil Obs.: No youtube.com, as video aulas não estão nítidas e apenas a metade das vídeo aulas estão aqui. Caso queira, posso enviar um dvd com centenas de vídeo aulas originais com alta qualidade, e você ainda vai receber todo o código fonte.
Views: 1187 Neri Neitzke
current date SQL
 
01:01
Views: 11 Rafael Osuna
Função Oracle ROUND
 
08:34
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função ROUND faz o arredondamento dos valores e ela pode receber como parâmetro principal de entrada tanto um campo do tipo NUMBER como um DATE! SELECT first_name, salary / 2.7, round(salary / 2.7) AS ROUND, FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, salary / 2.7, round(salary / 2.7, 2) AS ROUND FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, hire_date, round(hire_date, 'MONTH') AS ROUND FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, hire_date, round(hire_date, 'DAY') AS ROUND FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, hire_date, round(hire_date, 'YYYY') AS ROUND FROM hr.employees WHERE job_id ='IT_PROG'; Veja os outros vídeos da nossa Playlist https://www.youtube.com/watch?v=PjaBYIwXf8c&list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 541 Aprenda PL/SQL
PL/SQL tutorial 18: DDL Trigger with Schema Auditing Example
 
08:12
Learn how to create a DDL Trigger in Oracle Database with Schema Auditing Example where we will learn how to keep an any on which object is created, altered or drop and by who. Manish Sharma From RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/DDL-Trigger Previous Tutorial ►PL/SQL Tut 14 Triggers Introduction https://youtu.be/R3fvX_xf5P4 ► PL/SQL Tut 17 Table Backup Using DML Trigger https://youtu.be/jSv1LIlNKU0 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 39178 Manish Sharma